Hi!

Enter this formula in cell B1:

=COUNTIF(A:A,"Apple")

Biff

"smash123" wrote in
message ...

HI,

Need qucik answer

Want to know how can the excel auto count how many Apple in the column
A and show the result in B1?

Thank you for your help!


--
smash123
------------------------------------------------------------------------
smash123's Profile:
http://www.excelforum.com/member.php...o&userid=29974
View this thread: http://www.excelforum.com/showthread...hreadid=550892