Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
suming under two condintions
Here is what i have i have a table that has 5 columns; Category, Date,
Amount, Description, Location. i have made these columns as References if that helps too. What i want is a formula that i can use to sum a full days worth of data. For instance i would like to sum all data that is on in the category of Accounts payable on the day of 10/18/2009. I have already tried the SUMPRODUCT function and it is giving me #NUM. here is my formula what am i doing wrong. =SUMPRODUCT((Date=A24)*(Category=$E$3)) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
suming under two condintions
i also forgot what i want it to do is sum the Amounts for the day according
to the two conditions, i just figured out that my formula would not work, but if someone can give me a formula to sum the Amounts, according to the category and dates matching i would appreciate it, sorry for the confusion. "Soccerboy83" wrote: Here is what i have i have a table that has 5 columns; Category, Date, Amount, Description, Location. i have made these columns as References if that helps too. What i want is a formula that i can use to sum a full days worth of data. For instance i would like to sum all data that is on in the category of Accounts payable on the day of 10/18/2009. I have already tried the SUMPRODUCT function and it is giving me #NUM. here is my formula what am i doing wrong. =SUMPRODUCT((Date=A24)*(Category=$E$3)) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
suming under two condintions
SUMPRODUCT function and it is giving me #NUM.
=SUMPRODUCT((Date=A24)*(Category=$E$3)) Are you referencing entire columns in your named ranges like A:A ? If you're not using Excel 2007 then you can't reference entire columns with SUMPRODUCT. I assume A24 is some date. Try something like this: =SUMPRODUCT(--(A1:A20=A24),--(B1:B20=$E$3),C1:C20) Where C1:C20 is the sum range. -- Biff Microsoft Excel MVP "Soccerboy83" wrote in message ... Here is what i have i have a table that has 5 columns; Category, Date, Amount, Description, Location. i have made these columns as References if that helps too. What i want is a formula that i can use to sum a full days worth of data. For instance i would like to sum all data that is on in the category of Accounts payable on the day of 10/18/2009. I have already tried the SUMPRODUCT function and it is giving me #NUM. here is my formula what am i doing wrong. =SUMPRODUCT((Date=A24)*(Category=$E$3)) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
suming every 3rd column | Excel Worksheet Functions | |||
testing while suming | New Users to Excel | |||
suming in add-ins | Excel Worksheet Functions | |||
Suming up a Lookup | Excel Worksheet Functions | |||
Suming 2 cells if 1 = #N/A | Excel Worksheet Functions |