YTD sum range

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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)))
 
=SUM(A1:INDEX(A:A,MONTH(TODAY())))

--
HTH

Bob

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