Sumproduct on multiple criteria across rows and columns

[goo89]

<tbody>
</tbody>

Hi all,

https://imgur.com/a/X0sW0kE

Would anyone know a formula which sums all oranges in january, but only if the value of the cell is at most 10? So in the attached example it would come to 19. I have had a play with the SUMPRODUCT formula but can't get this to work. Happy to add additional tables to lookup if that makes it easier and it can't be captured in a single formula.

Thanks

 

[steve the fish]

Try:

=SUMPRODUCT((B1:E1=I3)*(A3:A6=I4)*(B3:E6 < I5)*B3:E6)<i5)*b3:e6)< html=""></i5)*b3:e6)<>

 

[goo89]

Try:

=SUMPRODUCT((B1:E1=I3)*(A3:A6=I4)*(B3:E6 < I5)*B3:E6)<i5)*b3:e6)< html=""></i5)*b3:e6)<>

Thank you, much appreciated!