I am trying to create a formula that will look in 3 columns containing 300 rows, and give an answer if the criteria in all 3 columns is met on a single row.
example: A B C
1 Blue Bag 60
2 Red Bag 100
3 Blue Bag 60
I want to check ALL the rows in the 3 columns that satisfy the criteria "Blue" and "Bag" and "60" and count how many times this occurs.
I have tried COUNTIF but with no success, unless I am doing it wrong.
Any help would be much appreciated.