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