countif bigger than zero fractions
 

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

countif bigger than zero fractions
 

With:
A1:B4 containing this list
Apples 2
Pears 3
Oranges (blank)
Bananas 1/2

I'm guessing that the 1/2 quantity for Bananas is text, and not a number.
Try entering it this way: 0 1/2
(that's a zero, a space, then 1/2)

Also....Isn't the produce type in Col_A and the quantity in Col_B?

So the formula would be:
C1: =COUNTIF(B1:B4,"=0")
In the above example, C1 returns 3

Alternatively..assuming there would be no negative quantities
You could use this formula
C1: COUNT(B1:B4)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"the-big-john" wrote:

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

countif bigger than zero fractions
 

Hi

The following will count all the non-blanks (but not necessarily the
numerics):

=COUNTIF(A1:A4,"<")

Best regards

Richard

On 26 Jan, 14:13, the-big-john
wrote:
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")

countif bigger than zero fractions
 

This is somewhat helpful. But Excel doesn't seem to handle fractions the way
I would like them. Even if it is 0/26. It converts it to 0, but I like to see
the distinction to see the number of apples possible in a container.


"Ron Coderre" wrote:

With:
A1:B4 containing this list
Apples 2
Pears 3
Oranges (blank)
Bananas 1/2

I'm guessing that the 1/2 quantity for Bananas is text, and not a number.
Try entering it this way: 0 1/2
(that's a zero, a space, then 1/2)

Also....Isn't the produce type in Col_A and the quantity in Col_B?

So the formula would be:
C1: =COUNTIF(B1:B4,"=0")
In the above example, C1 returns 3

Alternatively..assuming there would be no negative quantities
You could use this formula
C1: COUNT(B1:B4)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"the-big-john" wrote:

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