=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" wrote
in message ...
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 |
+-------------------------------------------------------------------+
--
Gunner204
------------------------------------------------------------------------
Gunner204's Profile:
http://www.excelforum.com/member.php...o&userid=32012
View this thread: http://www.excelforum.com/showthread...hreadid=517553