Hi all

Hopefully you can help me with what I'm guessing is an embarrassingly simple thing I cannot get my head round.

I have a sheet of results which will be updated with 'y' when a test is successful.

I want to be able to count the 'y' entries in Column G when the value if Column A is a certain value ie 'Fred'

Many thanks in advance,
G