Count

[Brucelee]

Hi I would like all of the cells that contain anything in a column to report a column total.
Something like COUNTIF(C11:C250,"apple")
but i dont want it to find all of the apples and count them I want it to find everything in tyhe column and total how many there are.

A
Strong flour
Regal ice(White)
Regal ice(Green)
Regal ice(Brown)
Regal ice(black)
Cinnamon
Caramel doughnuts
as you like it bread flour

Total = 8

like that

 

[Aladin Akyurek]

On 2002-04-25 08:33, Brucelee wrote:
Hi I would like all of the cells that contain anything in a column to report a column total.
Something like COUNTIF(C11:C250,"apple")
but i dont want it to find all of the apples and count them I want it to find everything in tyhe column and total how many there are.

A
Strong flour
Regal ice(White)
Regal ice(Green)
Regal ice(Brown)
Regal ice(black)
Cinnamon
Caramel doughnuts
as you like it bread flour

Total = 8

like that

Try:

=COUNTA(C11:C250)

Aladin

 

[Mark W.]

Enter the formula...

="Total = "&COUNTA($A$1:OFFSET(A10,-1,))

...into cell A10.

 

[Brucelee]

Thanks alot that worked great