Countif, if ??

  • Thread starter Thread starter SteveMc
  • Start date Start date
S

SteveMc

I have apples, oranges, etc. in the B column.
I'm counting the apples via:

=COUNTIF(B:B,"apples")
In the a column I have quality codes, r=rotten, g=good,
etc.

How can I count how many r's are accociated with the
apple count ?

Thanks,
 
use sumproduct which can NOT do whole columns.
=sumproduct((a2:a200="r")*(b2:b200="apples"))
 
Thank you very much

-----Original Message-----
use sumproduct which can NOT do whole columns.
=sumproduct((a2:a200="r")*(b2:b200="apples"))

--
Don Guillett
SalesAid Software
(e-mail address removed)



.
Click to expand...
 
Hi,

I have beén looking actually for the similar problem, but I hav
problems when applying the SUMPRODUCT to my problem.
Actually I have also two column containing the criterias, but in one o
these column the "#N/A" exists in several occasions due to othe
calculation results.
My SUMPRODUCT gives as an result also "#N/A". Might this be due to th
"#N/A" already in one of the input columns ?!?!?

Looking forward to your replies.
Heik
 
Back
Top