Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Multiple Qualifiers
0 views
Skip to first unread message
HeatherMichelle
Jan 4, 2010, 3:06:01 PM1/4/10
to
I am trying to s
HeatherMichelle
Jan 4, 2010, 3:11:01 PM1/4/10
to
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%
>= 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
JLatham
Jan 4, 2010, 10:54:01 PM1/4/10
to
The second part of your column, according to your example should refer to
column D, not S.
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).
0 new messages