Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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") |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to prevent Excel converting imported fractions into dates | Excel Discussion (Misc queries) | |||
Countif Formula /Sort Bug??? | Excel Discussion (Misc queries) | |||
COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
Combining IF and COUNTIF based on two columns | Excel Discussion (Misc queries) | |||
Countif - Countif | Excel Worksheet Functions |