Formula help

[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

 

[Pete_UK]

Try this in F7:

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

then copy down to F27.

Hope this helps.

Pete

 

[moily]

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

 

[Pete_UK]

You're welcome, Ann - thanks for feeding back.

Pete