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
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