EXCEL question

TarfHead said:
...
I know it's a form of COUNTIF, but can't recall the specification of the criteria, e.g. =COUNTIF(A1:E5,"=John"), except a cell reference would be used instead of the literal 'John'. IIRC, it involved using a single or double ampersand (&)....
Click to expand...

Might you be thinking of COUNTIFS?
The COUNTIFS equivalent of =COUNTIF($A$1:$E$5,G1) would be =COUNTIFS($A$1:$E$5,"="&G1).
 
Thanks for those replies.

Yes, the single cell reference does work, so I don't need the previous solution. Just bugs me that I can't remember, or find that document
 
You must log in or register to reply here.
Menu
Log in
Register