=SUMIF(A2:A20,"="&TODAY(),B2:B20)

however that assumes that the "dates" are real excel dates and not text

=SUMPRODUCT(--(A2:A20=TEXT(TODAY(),"mmmm dd")),B2:B20)

--
Regards,

Peo Sjoblom

(No private emails please)


"Vince281" wrote in
message ...

Hi All
I need to summarise the total of entries for a particular day in a
table like this :


Date Sale
June 01 50.00
June 01 50.00
June 03 60.00
June 03 20.00
Etc.


How do I get just today's sales ? i.e. I just want to have a cell like
this :


Today's sales are : 80.00

(as today is June 3rd).


Been looking at COUNTIF but just can't work it out.
Do I need to do a range somehow ? Help much appreciated !


--
Vince281
------------------------------------------------------------------------
Vince281's Profile:
http://www.excelforum.com/member.php...o&userid=24084
View this thread: http://www.excelforum.com/showthread...hreadid=376893