One way:
="Today's sales a " & TEXT(SUMIF(A:A,TODAY(),B:B),"00.00")
In article ,
Vince281
wrote:
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 !