| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct using NOT equal to
I have a sumproduct formula that i am trying to sum all cells in arow that
are not already included in my formula. I am sure this can be done by incorporating the NOT funtion, but I do NOT know how to execute this as an array. Here is my attempt that returns a #value error. =SUMPRODUCT("'Wholesale Orders'!E:E),--(=not(='Project Forecast'!A6:A22),('Wholesale Orders'!F:F) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMPRODUCT Can I use less than or equal to with this function | Excel Discussion (Misc queries) | |||
| 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) | |||
Threaded Mode
