Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Qualifiers
I am trying to do a Count to get the number of locations that have a total of
= 22 This is the incorrect formula: =SUMPRODUCT(--(Data!$F$1:$F$19272=51160),--(Data!$S$1:$S$19272=22)), my desired answer would be 1, or 50% Column F Column D 51160 34 51160 20 230 10 230 62 20 28 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Qualifiers
The second part of your column, according to your example should refer to
column D, not S. But if the smaller numbers really are in S, then you need to examine both columns and make sure the numbers are really numbers, and not text. Your formula works just fine for me (returns 1) when the proper columns are referenced). "HeatherMichelle" wrote: I am trying to do a Count to get the number of locations that have a total of = 22 This is the incorrect formula: =SUMPRODUCT(--(Data!$F$1:$F$19272=51160),--(Data!$S$1:$S$19272=22)), my desired answer would be 1, or 50% Column F Column D 51160 34 51160 20 230 10 230 62 20 28 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I set up an IF formula with multiple qualifiers? | Excel Discussion (Misc queries) | |||
COUNTIF with additional qualifiers? | Excel Worksheet Functions | |||
Table lookup using multiple qualifiers | Excel Discussion (Misc queries) | |||
Saving as a csv file with text qualifiers | Excel Discussion (Misc queries) |