Counting cells with text in another cell, instead of counting cells with certain text

[Jodiemh]

Hello everyone I'm using this expression

=COUNTIFS(B:B,"A", F:F,"Mary")

To count certain grading in one column, B, and certain names in another column, F, and give me a number of how many there are.

I was wondering if there was a way to instead of finding if cells in the F column have a certain name, it could check if certain cells in that column contained text that's the same in another cell, let's call is K10. That way I don't have to change all the expressions if say, Mark got replaced by John. I could just change the name in that one cell, K10 and all the expressions would still work.

[alansidman]

Please read the yellow banner at the top of this page on how to attach a file.

[Fluff13]

How about
=COUNTIFS(B:B,"A", F:F,$K$10)