Sumproduct IF Q

  • Thread starter Thread starter Sean
  • Start date Start date
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
 
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
 
=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)
 
=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
 
Sorry, I read that as D-B for some reason

=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)
 
Back
Top