Formula help

  • Thread starter Thread starter moily
  • Start date Start date
M

moily

Hi there,

I have a worksheet that, in F7:F27, has a sum function in each cell. This
is a bit confusing so I hope I get it right! The cells I6:T6 have dates in
them for each month of the year (01-01-09, 01-02-09, 01-03-09, etc). For
each row in F of 7:27 I need to calculate the current sum in that row as of
today's month. So, since this is still April my formula in F7 should sum
cells I7:L7, my formula in F8 should sum cells I8:L8, my formula in F9 should
sum cells I9:L9, etc. However, on Friday we will be in May so my formula in
F7 should sum cells I7:M7, my formula in F8 should sum cells I8:M8, my
formula in F9 should sum cells I9:M9, etc. What would be the best formula to
do this?

Thanks in advance for any help you can provide!

Cheers,
Ann
 
Try this in F7:

=SUMIF(I$6:T$6,"<="&TODAY(),I7:T7)

then copy down to F27.

Hope this helps.

Pete
 
Hi Pete,

That's perfect - I feel so silly 'cause I eventually came up with the exact
same thing! At the very least I gues it means it's the best, if not only,
method! :)

Cheers,
Ann
 
Back
Top