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.