Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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") |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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") |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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") |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |