Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Need help with Excel Formula for calculating sum of products depending on criteria
Hi,
I need help for a Excel formula - I want cells C19, C20, C21 to sum the values of the categories in column D, if the category cell(column D) is empty I would like the number to summed up as category SP. "C Column" "D Column" USD March Category 10 SP 30 TP 20 SP 10 5 SP 15 TP 5 DI 7 DI 5 5 8 SP 10 TP 15 DI 145 SUM SP SUM TP SUM DI I am using below formula but do not know how to check if cell value is blank : =SUMIF(D4:D16,"SP",C4:D16) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help with Excel Formula for calculating sum of products depending on criteria
Hi Archi,
Am Mon, 12 Mar 2012 09:55:31 +0000 schrieb Archi G: I am using below formula but do not know how to check if cell value is blank : =SUMIF(D4:D16,"SP",C4:D16) D21: =SUMIF(D4:D16,"DI",C4:C16) D20: =SUMIF(D4:D16,"TP",C4:C16) D19: =SUM(C4:C16)-D20-D21 Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help with Excel Formula for calculating sum of products depending on criteria
Hi Archie,
Am Mon, 12 Mar 2012 15:26:24 +0100 schrieb Claus Busch: D21: =SUMIF(D4:D16,"DI",C4:C16) D20: =SUMIF(D4:D16,"TP",C4:C16) D19: =SUM(C4:C16)-D20-D21 or you use for SP: =SUMPRODUCT(((D4:D16="SP")+(D4:D16=""))*C4:C16) Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRODUCT Formula Not Calculating with 2 criteria | Excel Programming | |||
calculating values depending on columns in different wkbooks. | Excel Programming | |||
Calculating Daily Averages for Different Products | Excel Programming | |||
calculating different percentages depending on amount | Excel Discussion (Misc queries) | |||
Calculating totals depending on cell value | Excel Programming |