| 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) |
| 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 | |||
Threaded Mode
