YTD sum range
 

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.

YTD sum range
 

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

--
Regards

Roger Govier


"DC" wrote in message
...
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.

YTD sum range
 

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

--
HTH

Bob

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

"DC" wrote in message
...
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.