help with SUMIF

**Gunner204** · 02-28-2006, 07:59 PM

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.

Bob Phillips · 02-28-2006, 08:25 PM

=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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>