Probably not the correct terminology. I am currently using `find / replace` to do this, which does do the job satisfactorily.
Formula: COUNTIF(Apr!E:E,"John") Ok one can see this adds up the entries for John in sheet Apr, column E
As there are several names, Mary, Jean etc and many entries for each name I just wondered if part of the formula could be referenced from another sheet, something like COUNTIF(Apr!E:E,"=names! B6")
It is not an issue for me but thought I would ask the question if it were possible, I couldnt find anything on google.
Thank you
Bookmarks