Sum total numbers for only a certain date

**Craddock** · 06-15-2009, 10:09 AM

I'm working on an excel for work. It lists the days on the column farthest left, and with some variables calculates the total number of tons we have for the day on another column. For part of it I'm wanting the program to calculate how many tons we process for each day. The problem is that each days will have a different number of entries.

For example:

June first has 6 entries
June second has 3 entries
June third has 4 entries

So I'm wanting to make another column seperate from the original data that calculates total number of tons from the entries for the day without saying cell=sum(the 6 entries from the first), cell=sum(3 entries from the second).

I'm not sure how to go about this, I thought if I could get a recurring if statement that would test all of the entries for the date, and if it matches sum them up. I'm just not sure how to go about it.

Any suggestions?

**daddylonglegs** · 06-15-2009, 10:14 AM

If you have dates in column A and amounts in B you can use a SUMIF formula like this

=SUMIF(A:A,D2,B:B)

where D2 contains the specific date for which you want to sum