View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
the-big-john the-big-john is offline
external usenet poster
 
Posts: 1
Default 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")