Sorry, I may be dense but how does that reference C?


"Frank Kabel" wrote:

Hi
try
=COUNTIF(B:B,"Bob")

--
Regards
Frank Kabel
Frankfurt, Germany

"JohnT" schrieb im Newsbeitrag
...
I have a spreadsheet with data in column B that I want to show in
Column D if
column C = Bob
I tried COUNTIF but can't get it happening.
Thanks in advance!