auto count how many Apple
 

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

auto count how many Apple
 

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

auto count how many Apple
 

In B1 enter this formula.

=COUNTIF(A:A,"Apple")


Gord Dibben MS Excel MVP


On Mon, 12 Jun 2006 00:13:23 -0500, smash123
wrote:


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!