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.
Bookmarks