| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMPRODUCT Can I use less than or equal to with this function
Thank you Paul :-)
Cheers -- Mifty "PCLIVE" wrote: Try this: =SUMPRODUCT(($C$2:$C$16010=R2)*($E$2:$E$16010="Mat ")*($F$2:$F$16010="AT1")*($K$2:$K$16010<=35)) I prefer this method. Though the result is the same. =SUMPRODUCT(--($C$2:$C$16010=R2),--($E$2:$E$16010="Mat"),--($F$2:$F$16010="AT1"),--($K$2:$K$16010<=35)) HTH, Paul -- "Mifty" wrote in message ... 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMPRODUCT not equal to... | Excel Worksheet Functions | |||
| SUMPRODUCT - How can I use does not equal in an array? | Excel Worksheet Functions | |||
| GREATER OR EQUAL TO BUT LESS THAN Problem using Sumproduct | Excel Worksheet Functions | |||
| SumProduct - Value ISN'T equal to | Excel Discussion (Misc queries) | |||
| IF function... not equal to | Excel Worksheet Functions | |||
Threaded Mode
