View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mifty Mifty is offline
external usenet poster
 
Posts: 99
Default SUMPRODUCT Can I use less than or equal to with this function

Hi there,

I'm using this formula but can I amend it so that it counts less than or
equal to 35 rather thatn just 35?

=SUMPRODUCT(($C$2:$C$16010=R2)*($E$2:$E$16010="Mat ")*($F$2:$F$16010="AT1")*($K$2:$K$16010=35))

Grateful for any help

Cheers
--
Mifty