Posts by Muppley

    Hi


    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.