Help with sumif

[wa4441]

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

[Kevin@Radstock]

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)))