Sumproduct IF Q

S

Sean

I wish to Sumproduct Col B x D (from rows 5 to 10) but only if the
Value in Col M5:10 = Cars

So I could have a scenario of

ColB5 x ColD5 +
ColB7 x ColD7 +
ColB8 x ColD8 +
ColB10 x ColD10 =

As M6 & M9 were not = Cars, then I ignored them from my Calculation

Thanks
 
R

Ron Coderre

Try this:

=SUMPRODUCT(B5:B10,D5:D10,--(M5:M10="Cars"))
or
=SUMPRODUCT(B5:B10*D5:D10*(M5:M10="Cars"))


Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
B

Bob Phillips

=SUMPRODUCT(--(M5:M10="Cars"),(D5:D10-B5:B10))

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
S

Sean

=SUMPRODUCT(--(M5:M10="Cars"),(D5:D10-B5:B10))

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)










- Show quoted text -
Click to expand...

Thanks guys it works a treat
 
Top