YTD sum range

[Guest]

I want to automate a sum to take account of each month as each month passes.
For example, I have a 'Year to Date' column that I want to automatically
update when I change the reporting month, so if I entered 'May' the column
would sum the range from Jan to May.

Please help.

 

[Roger Govier]

Hi

One way
Assuming you have in B1:M1 the text Jan, Feb ... Dec
In cell P1 enter May
In cell P2
=SUM($B2:INDEX($B2:$M2,MATCH($P$1,$B$1:$M$1,0)))

 

[Bob Phillips]

=SUM(A1:INDEX(A:A,MONTH(TODAY())))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)