SUMPRODUCT function to return only the sum of cells which are less than a given number.

Hi Everyone,


Anyone have any ideas as to how I can tweak the following working formula to return only the sum of cells which are less than a given number.

The working formula as per my attached worksheet I have is: =SUMPRODUCT((B2:B20=17)*(D2:K20))

The formula is returning the sum of those values which match the criteria number 17 but I would only like the values which are less than "300" returned.

Therefore i would like the total figure in cell O2 to reflect as "110" and not "410"

I have attached a sample worksheet for your reference.


Many Thanks,


Bobby.

How about
=SUMPRODUCT((B2:B20=17)*(D2:K20<300),D2:K20)

Many thanks once again for your assistance Fluff.

You have come up trumps once again!

Regards,

Bobby.

Glad to help & thanks for the feedback.