G
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 |
+-------------------------------------------------------------------+
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 |
+-------------------------------------------------------------------+