COUNTIF with LOGIC

I am trying to count the number of cells containing a specific text value in different columns based on information contained in a different column.

For example, i would like to count the number of cells that contain “A” in 1 of 3 different columns dependant on a revision number, 0, 1 or 2 and only return the count in the most recent column of information.

By: Dan

Leave a Reply

Your email address will not be published. Required fields are marked *