Totaling Invoices by Date

C

CookinGuy

Can someone tell me how to make Excel 2000 add up all the invoices on a certain date automatically? For example- (in this order)

6/1/04 $34.45
6/1/04 $23.87
6/5/04 $12.56
6/3/04 $10.00
6/1/04 $100.00

Would return something like this-
6/1/04 $158.32
6/2/04 $0
6/3/04 $10
6/4/04 $0
6/5/04 $12.56

Currently, I am totaling it up myself which can get to be kind of a pain. I know it can be done but I am not sure if it can be done with Excel 2000 or not. Is it a macro? Thanks a billion.
 
D

Domenic

Hi,

Assuming you use your data from your first table, starting at A1, one
way would be to list your dates in a column, lets say Column A, starting
at A10, like you've done,

6/1/04
6/2/04
6/3/04
6/4/04
6/5/04

and enter the following formula in B10, and copy it down as far as you
need to:

=SUMPRODUCT((DAY($A$1:$A$5)=DAY(A10))*(MONTH($A$1:$A$5)=MONTH(A10))*(YEAR
($A$1:$A$5)=YEAR(A10)),$B$1:$B$5)

Another way, might be to use a PivotTable which would easily group them
by date.

Hope this helps!
 
Top