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