Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SUMPRODUCT
I want to sum column "C15:20,C30:C40,C50:C200" with numbers in it, only if
columns "D" or "E" do not have the text of "fill" or "FILL" in either one. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
SUMPRODUCT
Do columns C and E have the text "fill" in rows 15:20, 30:40, 50:200?
"Sean" wrote: I want to sum column "C15:20,C30:C40,C50:C200" with numbers in it, only if columns "D" or "E" do not have the text of "fill" or "FILL" in either one. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct with Condition OR Sumproduct with ADDRESS function - HE | Excel Discussion (Misc queries) | |||
sumproduct | Excel Discussion (Misc queries) | |||
sumproduct? | Excel Discussion (Misc queries) | |||
Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions |