help with SUMIF

[Gunner204]

I'm not sure if I am using the correct function. What I'm trying to do
is have excel look at my data and total up my amount per category per
date.

Example:
Sheet Name Data:

A B C
1 Amount Category Receipt Date
2 4.5 Tolls 2/14/2006 0:00
3 2.65 Tip 2/13/2006 0:00
4 1 Tolls 2/14/2006 0:00
5 3 Tolls 2/13/2006 0:00


Total Tolls for 2/13/2006 = ....

This is the what I am formula I'm using and all it does is toals all
"tolls", I can get it to break it down per date.

=SUMIF(Data!B2:B100,"tolls",Data!A2:A100)

Attached is a copy of my report.

Any Help would be great.


+-------------------------------------------------------------------+
|Filename: Report.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4401 |
+-------------------------------------------------------------------+

 

[Bob Phillips]

=SUMPRODUCT(--(Data!B2:B100="tolls"),--(Data!C2:C100=--"2006-02-13"),Data!A2
:A100)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Gunner204]

Bob,

That worked great thanks for your help

 

[Bob Phillips]

No problem.