Excel Stats ...

Aphrael

Expert Member
Joined
Aug 17, 2006
Messages
1,110
Hi guys

I hate to bother you with something so trivial, but I'm not having any luck by myself. :eek: Basically, I'm compiling stats for my team and hit a brick wall. What I need is some kind of formula that checks Column A, finds the word Fruit, then checks Column B and counts how many times the word Apple is found ...

I have tried the if-statement, but it seems to focus only on one cell, not a range, like I need. Your help is appreciated and an example is shown below.

Regards

Aphy


So, like this ...

Fruit Apple
Fruit Pear
Veg Carrot
Fruit Banana

Result: 1
 

Aphrael

Expert Member
Joined
Aug 17, 2006
Messages
1,110
Yes ... count if works on a single column ... need it over 2 columns ...
Basically ... =If(A:A="Fruit",Countif(B:B,"Apple"),"") ... BUT, A:A does not work.
 

bekdik

Honorary Master
Joined
Dec 5, 2004
Messages
12,860
Yes ... count if works on a single column ... need it over 2 columns ...
Basically ... =If(A:A="Fruit",Countif(B:B,"Apple"),"") ... BUT, A:A does not work.

Why? Does apple also appear as veg?
 
Top