Notifications
Clear all
Topic starter
Hi Expert,
I Have data from Jan To Dec
in cell A1 I use data validation it pops up Jan thru Dec
Data as below
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec start in row B2 vertically
10 20 30 40 50 60 70 80 90 100 110 120 start in row B3 vertically too
I Want like this if I select Mar from
Cell A1
In Cell B5 it sums from Jan to Mar
If i choose Nov it sums from Jan to Nov
What formula i can do?
thanks,
Posted : 14/03/2017 11:45 pm
Hi mey
There may be a better solution but you can try this for now.
I would prefer you to include an attachment the next time as it will be easier for members to answer your question without having to recreate the data.
Sunny
Posted : 15/03/2017 12:56 am
Topic starter
Yes,thank you
Posted : 15/03/2017 2:50 am
Hi mey
I have a 2nd method for you.
Sunny
Posted : 15/03/2017 3:40 am
