| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
SumProduct - Value ISN'T equal to
Hi All,
I am trying to use the following formula to count the number of entries that are not Closed:- =SUMPRODUCT((Val_RSK_Status<"Closed")*(Val_RSK_Ow ner="Jim")) It produces a result, but not the right one - have I got the Syntex for Not Equal to Right? Thanks in advance Andy |
|
#2
|
|||
|
|||
|
Your syntax is fine. What is the error?
Your formula will count blanks as <"Closed". If you don't want that, one way is: =SUMPRODUCT(--(Val_RSK_Status<"Closed"), --(Val_RSK_Status<""), --(Val_RSK_Owner="Jim")) In article , "Andibevan" wrote: Hi All, I am trying to use the following formula to count the number of entries that are not Closed:- =SUMPRODUCT((Val_RSK_Status<"Closed")*(Val_RSK_Ow ner="Jim")) It produces a result, but not the right one - have I got the Syntex for Not Equal to Right? Thanks in advance Andy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying conditional formatting...HELP PLEASE!!!! | Excel Worksheet Functions | |||
| Sumproduct | Excel Worksheet Functions | |||
| Can I reference =, <, or > sign in SUMPRODUCT | Excel Discussion (Misc queries) | |||
| Sumproduct function not working | Excel Worksheet Functions | |||
| adding two sumproduct formulas together | Excel Worksheet Functions | |||
Linear Mode
