# Thread: Using COUNTIF on cells with formulas

1. I am trying to count the number of cells in a column that contain the number 1. However, the cells being counted are actually formulas and if you PasteValues on the column most of the cells displaying a 1 are actually less than 1 or greater than one but less than 2. I think the formula needs to take the actual values into consideration. Something like, countif(value(range,">0")+countif(value(range,"<2" )))). I have something just not right because Excel doesn't like the formula. What am I not seeing?

TIA

2. I am trying to count the number of cells in a column that contain the number 1. However, the cells being counted are actually formulas and if you PasteValues on the column most of the cells displaying a 1 are actually less than 1 or greater than one but less than 2. I think the formula needs to take the actual values into consideration. Something like, countif(value(range,">0")+countif(value(range,"<2" )))). I have something just not right because Excel doesn't like the formula. What am I not seeing?

TIA

3. I am trying to count the number of cells in a column that contain the number 1. However, the cells being counted are actually formulas and if you PasteValues on the column most of the cells displaying a 1 are actually less than 1 or greater than one but less than 2. I think the formula needs to take the actual values into consideration. Something like, countif(value(range,">0")+countif(value(range,"<2" )))). I have something just not right because Excel doesn't like the formula. What am I not seeing?

TIA

4. I am trying to count the number of cells in a column that contain the number 1. However, the cells being counted are actually formulas and if you PasteValues on the column most of the cells displaying a 1 are actually less than 1 or greater than one but less than 2. I think the formula needs to take the actual values into consideration. Something like, countif(value(range,">0")+countif(value(range,"<2" )))). I have something just not right because Excel doesn't like the formula. What am I not seeing?

TIA

5. I am trying to count the number of cells in a column that contain the number 1. However, the cells being counted are actually formulas and if you PasteValues on the column most of the cells displaying a 1 are actually less than 1 or greater than one but less than 2. I think the formula needs to take the actual values into consideration. Something like, countif(value(range,">0")+countif(value(range,"<2" )))). I have something just not right because Excel doesn't like the formula. What am I not seeing?

TIA

6. I am trying to count the number of cells in a column that contain the number 1. However, the cells being counted are actually formulas and if you PasteValues on the column most of the cells displaying a 1 are actually less than 1 or greater than one but less than 2. I think the formula needs to take the actual values into consideration. Something like, countif(value(range,">0")+countif(value(range,"<2" )))). I have something just not right because Excel doesn't like the formula. What am I not seeing?

TIA

7. I am trying to count the number of cells in a column that contain the number 1. However, the cells being counted are actually formulas and if you PasteValues on the column most of the cells displaying a 1 are actually less than 1 or greater than one but less than 2. I think the formula needs to take the actual values into consideration. Something like, countif(value(range,">0")+countif(value(range,"<2" )))). I have something just not right because Excel doesn't like the formula. What am I not seeing?

TIA

8. I am trying to count the number of cells in a column that contain the number 1. However, the cells being counted are actually formulas and if you PasteValues on the column most of the cells displaying a 1 are actually less than 1 or greater than one but less than 2. I think the formula needs to take the actual values into consideration. Something like, countif(value(range,">0")+countif(value(range,"<2" )))). I have something just not right because Excel doesn't like the formula. What am I not seeing?

TIA

=COUNTIF(range,">0")-COUNTIF(range,">=2")

Steve

=COUNTIF(range,">0")-COUNTIF(range,">=2")

Steve

=COUNTIF(range,">0")-COUNTIF(range,">=2")

Steve

=COUNTIF(range,">0")-COUNTIF(range,">=2")

Steve

=COUNTIF(range,">0")-COUNTIF(range,">=2")

Steve

=COUNTIF(range,">0")-COUNTIF(range,">=2")

Steve

=COUNTIF(range,">0")-COUNTIF(range,">=2")

Steve

Page 1 of 2 12 Last

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•