Refining Countif

A

asg2307

I am using Countif as per this example =COUNTIF(Sheet2!$G$1:$G$30000,
"=redcat") . I would like to find only the redcat11 's only in one zip code
which is in column k. I have tried sumproduct and sum but they dont work.
There is on numerical value for redcat just the value redcat. Thanks.
 
D

Dave Peterson

=sumproduct(--(sheet2!$g$1:$g$30000="Redcat"),--(sheet2!$k$1:$k$30000=12345))

=sumproduct() likes to work with numbers.

the -- stuff converts trues and falses to 1's and 0's.

If the zip codes are text, use ="12345".

And you can't use the whole column in this kind of formula.
 
D

Dave Peterson

And I'm not sure how redcat11 fit in??

Dave said:
=sumproduct(--(sheet2!$g$1:$g$30000="Redcat"),--(sheet2!$k$1:$k$30000=12345))

=sumproduct() likes to work with numbers.

the -- stuff converts trues and falses to 1's and 0's.

If the zip codes are text, use ="12345".

And you can't use the whole column in this kind of formula.
Click to expand...
 
A

asg2307

This worked great. I ended up with a negative number, but resolved this by
putting a minus sign before sumproduct. Maybe if you have time you can tell
me how to properly write the formula.

Thanks!!

Alan
 
Top