Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi,
Looking for a Sumproduct formula that will add the quantities in Col. C that have (A in Col. A & "whatever" in Col. B) + Only those Quantities in Col. C that have (Blanks in Col. A & Non-Blanks in Col. B) Col. A Col. B Col. C F Blank 10 A Blank 20 Blank Blank 30 F Non-Blank 40 A Non-Blank 30 Blank Non-Blank 20 Eg: 20 + 30 + 20 = 70 Thanks in advance, bkt |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Compare row contents w/Sumproduct or Array formula? | Excel Worksheet Functions |