Excel - easy summary (I hope !)

  • Thread starter Thread starter Vince281
  • Start date Start date
V

Vince281

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. :confused:
Do I need to do a range somehow ? Help much appreciated !
 
have you tried the function sumif?

the criteria is
range
criteria
sumrange

range - select the column that has the dates of all the sales
criteria - select the one cell that has todays date (set cell value t
=today() )
sumrange - select the column next to the date range that has sales

to get the outcome that you were looking for select an empty cell an
type
="today's seles are "&C2)

where C2 is the cell with the sumif functio
 
One way:

="Today's sales are: " & TEXT(SUMIF(A:A,TODAY(),B:B),"00.00")
 
=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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

excel sales figures 2
formula to look at current date and markdown date to give price 4
Macro to delete rows 3
Calculating the monthly total 2
Customized Report Summary? 4
Choice of Formula 4
Sum values preceg today 1
How do I easily view trends over categories in my data 1

Back
Top