| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is sumproduct the answer?
I have a large table. I check to see if the value in row M is equal to
characters. If it is equal to characters I then need to count if the values in row DE are set to one of 6 different values |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is sumproduct the answer?
characters??
try this idea =SUMPRODUCT((E9:E19="characters)*(F9:F19={"a","b", "x"})) -- Don Guillett SalesAid Software "Mitchell" wrote in message ... I have a large table. I check to see if the value in row M is equal to characters. If it is equal to characters I then need to count if the values in row DE are set to one of 6 different values |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is sumproduct the answer?
Fantastic, Worked great Don, thanks for the help
"Don Guillett" wrote: characters?? try this idea =SUMPRODUCT((E9:E19="characters)*(F9:F19={"a","b", "x"})) -- Don Guillett SalesAid Software "Mitchell" wrote in message ... I have a large table. I check to see if the value in row M is equal to characters. If it is equal to characters I then need to count if the values in row DE are set to one of 6 different values |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct issues | Excel Worksheet Functions | |||
| Adding "OR" to a Sumproduct Formula | Excel Worksheet Functions | |||
| Need help with sumproduct & dynamic ranges | Excel Worksheet Functions | |||
| Need help with sumproduct and dynamic ranges | Excel Worksheet Functions | |||
| i cant get the exact answer e.g answer is 13.49% i got 13.00% | Excel Discussion (Misc queries) | |||
Linear Mode
