Help with sumif

W

wa4441

New member
Joined
May 10, 2013
Messages
3
Reaction score
0
Points
0
Hi I need help, simple calculation
JanFebMarAprMayJunJulAugSepOctNovDecTotal
Salary2468743234565772476


Need simple formula to calculate Mar YTD number referencing a changeable cell (exp, May, Dec)
I used this but it does not work =SUMIF($B$1:$M$1,">"&A6,$B$2:$M$2)

Hope you can help
 
Hi wa4441

Do you mean you want to sum the values up to Mar!
If so try the following, where A6 contains the month.

=SUM(B2:INDEX(B2:M2,MATCH(A6,B1:M1,0)))
 
You must log in or register to reply here.
Back
Top