View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bkt bkt is offline
external usenet poster
 
Posts: 5
Default Please help w/Sumproduct!

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