Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
SUMIF | Excel Worksheet Functions | |||
Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
SUMIF with Mutiple Ranges & Criteria | Excel Discussion (Misc queries) | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |