G
Guest
Hello, I am trying to get a single column to add up. The column contains a
number for a a type of produce.
Example:
Apples 2,
Pears 3,
Oranges 8,
Bananas 1/2.
I want to use a Countif function or something similar to add up the total
rows filled in case I miss a row. For example: if I leave Oranges blank it
will tell me I filled in 3 rows.
Right now it tells me I only have 2 rows filled because for some reason the
countif function I am using is telling me that I Bananas doesn't fulfill the
conditional I'm using.
My function is: =Countif(A1:A4,">=0")
number for a a type of produce.
Example:
Apples 2,
Pears 3,
Oranges 8,
Bananas 1/2.
I want to use a Countif function or something similar to add up the total
rows filled in case I miss a row. For example: if I leave Oranges blank it
will tell me I filled in 3 rows.
Right now it tells me I only have 2 rows filled because for some reason the
countif function I am using is telling me that I Bananas doesn't fulfill the
conditional I'm using.
My function is: =Countif(A1:A4,">=0")