=SUMIF(A5:AD5,A1,A6:AD6)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"edwardpestian"
wrote in message
news:edwardpestian.29tafd_1150993233.6508@excelfor um-nospam.com...

I have a range of dates for the month of June. A5:AD5. I have
corresponding data below each date. A6:AD6. I need to sum the data
values based on the date in a different cell. For example, if the date
in A1=06/22/2006, then I need to sum the values in the Range A6:AD6 for
the dates up to and including the 22nd.

Not sure where to start with this one.

Thanks.

ep


--
edwardpestian
------------------------------------------------------------------------
edwardpestian's Profile:
http://www.excelforum.com/member.php...o&userid=33809
View this thread: http://www.excelforum.com/showthread...hreadid=554637