auto count how many Apple

smash123 · Jun 12, 2006

HI,

Need qucik answer

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

Thank you for your help

Biff · Jun 12, 2006

Hi!

Enter this formula in cell B1:

=COUNTIF(A:A,"Apple")

Biff

Gord Dibben · Jun 12, 2006

In B1 enter this formula.

=COUNTIF(A:A,"Apple")

Gord Dibben MS Excel MVP