Hi I need help, simple calculation
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total Salary 2 4 6 87 4 3 2345 6 5 7 7 2476
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)))
Bookmarks