CountIF with dynamic criterion

Question

Hi i'm trying to count the number of rows in a Smartsheet where the name in the "Engineer" column is the same name in the "Approved By" column

I can get it to work by looking at a single row

=IF(Engineer4 = [Approved By]4, COUNT(Engineer4))

but seem to look at all the rows in both columns and count the rows that match, is this possible?

many thanks

Stewart Ennew · Accepted Answer

Ok if that is the best way to do it i will give it a crack, much appreciated