auto count how many Apple

[smash123]

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!

[Biff]

Hi!

Enter this formula in cell B1:

=COUNTIF(A:A,"Apple")

Biff

"smash123" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Gord Dibben]

In B1 enter this formula.

=COUNTIF(A:A,"Apple")


Gord Dibben MS Excel MVP


On Mon, 12 Jun 2006 00:13:23 -0500, smash123
<[email protected]> 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!