Refining Countif
Disregard the adding the negative sign comment. My error.
"Dave Peterson" wrote:
And I'm not sure how redcat11 fit in??
Dave Peterson wrote:
=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.
asg2307 wrote:
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.
--
Dave Peterson
--
Dave Peterson
|