Please help w/Sumproduct!
Hi again
I guess Franz Verga's 2nd formula will work for you
=SUMPRODUCT((A1:A6="A")*C1:C6)+SUMPRODUCT((A1:A6=" ")*(B1:B6<"")*C1:C6)
Thanks,
Shail
bkt wrote:
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
|