Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel - easy summary (I hope !)
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 |
#2
|
|||
|
|||
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 to =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 and type ="today's seles are "&C2) where C2 is the cell with the sumif function -- barrfly Excel User - Energy markets ------------------------------------------------------------------------ barrfly's Profile: http://www.excelforum.com/member.php...fo&userid=4141 View this thread: http://www.excelforum.com/showthread...hreadid=376893 |
#3
|
|||
|
|||
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 ! |
#4
|
|||
|
|||
=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 |
#5
|
|||
|
|||
Worked a treat. Thanks for amazingly quick suggestion. -- Vince281 ------------------------------------------------------------------------ Vince281's Profile: http://www.excelforum.com/member.php...o&userid=24084 View this thread: http://www.excelforum.com/showthread...hreadid=376893 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
VBA for Excel 2000 file is corrupt | Excel Discussion (Misc queries) | |||
Slight problem automating Excel in a service | Setting up and Configuration of Excel | |||
Excel Files Acting Weird | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) |