Adding values reference to date today

**xmoore** · 12-14-2009, 06:45 AM

Hi,

I trying to get a faster way on how to sum numbers reference to the current date. Basically I have the following data

a,b,c,d,e,f,g,h,J
name,12/11/09,12/12/09,12/13/09,12/14/09,12/15/09,12/16/09,12/17/09,total
thomas,3,2,0,1,10,5,8,
jefferson,2,3,4,5,6,7,8,

I wanted to get the sum of the rows only upto the current date.
So if today's date is 12/13/09 column J should have total of = 5 and 7 for thomas and jefferson respectively. Tomorrow's date should include numbers of 12/14/09.
cant seem to work around with the today() function.

Hope you could shed your thoughts

thanks

**rwgrietveld** · 12-14-2009, 06:55 AM

Can do this in I2

Code:

=SUMIF($B$1:$H$1,"<"&TODAY(),B2:H2)

**xmoore** · 12-14-2009, 10:59 PM

Thanks rwgrietveld,

It did worked. However let me elaborate it further. My mistake should have given this sample instead.
Need to sum only what the column reference and up to todays date only

**xmoore** · 12-14-2009, 11:02 PM

the attachment

**davesexcel** · 12-14-2009, 11:12 PM

Use "<="

**xmoore** · 12-14-2009, 11:39 PM

Thanks davesexcel,
I already incorporated "<=" to the formula.
SUMIF($D$1:$W$1,"<="&TODAY(),D3:W3)

I was having difficulty in summing selective columns.For instance I only need the sum of actual column.
Tried to tweak the formula a bit to the following, which looks to be computing fine, though I still need to verify
SUMIF($E$1:$W$1,"<="&TODAY(),E3:W3)

thanks guys.