You can. Say your range is A1:A8.
COUNTIF(A1:A8,"Coke")
HTH Otto
"Boulder257" wrote
in message ...
Why can't I count the number of cells filled with text? For instance,
let's say I have Column A filled with either Coke or Pepsi. Why can't I
just count the number of Coke?
--
Boulder257
------------------------------------------------------------------------
Boulder257's Profile:
http://www.excelforum.com/member.php...o&userid=20053
View this thread: http://www.excelforum.com/showthread...hreadid=505356