Hi guys
I hate to bother you with something so trivial, but I'm not having any luck by myself.
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
I hate to bother you with something so trivial, but I'm not having any luck by myself.
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