help with SUMIF
 

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

help with SUMIF
 

=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

help with SUMIF
 

Bob,

That worked great thanks for your help:)


--
Gunner204
------------------------------------------------------------------------
Gunner204's Profile: http://www.excelforum.com/member.php...o&userid=32012
View this thread: http://www.excelforum.com/showthread...hreadid=517553

help with SUMIF
 

No problem.

"Gunner204" wrote
in message ...

Bob,

That worked great thanks for your help:)


--
Gunner204
------------------------------------------------------------------------
Gunner204's Profile:
http://www.excelforum.com/member.php...o&userid=32012
View this thread: http://www.excelforum.com/showthread...hreadid=517553