Countif, if ??

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,
 
D

Don Guillett

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

Guest

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...
 
H

heiko

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Simple nested if and statement 2
Unable to identify appropriate formula for very simple scenario 2
Lookup function to return highest value 4
Define a Range based on Cell Values 2
Count no. of occurance in 2 dynamic columns within a data period 7
Copy text into blank rows 2
V-lookup and Countif 2
How can you replace specific characters in a string ? 2

Top