# Count negative and some positive values

#### NealS26

##### New Member
How can I count two sets of values in Excel. I am trying to count all values that are less than Zero plus columns with a value of ".55".

I have tried =Count(IF(SumRange1,"<0",IF(SumRange1,"0.55",SumRange1))).

I get a value if I only use <0 argument but If I add the "0.55" I do not get any value. Nor do I get an answer with "0.55" by itself.

=COUNT(IF(SumRange1,"0.55",SumRange1)) Produces 0

=COUNTIF(SumRange1,"0.55") does provide the correct answer 1.

=(COUNTA(IF(SumRange1<>"0",IF(SumRange1<>".1",IF(SumRange1<>".35"
,IF(SumRange1<>".65",IF(SumRange1<>".9",IF(SumRange1<>"1"
,SumRange1)))))))) - Does not count negative numbers or .55 ( Also used Just COUNT on the front instead of COUNTA here as well with the same results.

thanks. -Neal

### Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

#### dafan

##### Well-known Member
Try this:
Code:
``=COUNTIF(SumRange1,"<0")+COUNTIF(SumRange1,"=0.55")``

And welcome to the board of course!

Last edited:

#### jindon

##### MrExcel MVP
try
=Sum(CountIf(SumRange1,{"<0","0.5"}))

#### jindon

##### MrExcel MVP
Try to give an example along with the expected outcome...

Does

trying to count all values that are less than Zero plus columns with a value of ".55"

mean that you have multiple ranges to process or is it just a single range?

How can I count two sets of values in Excel. I am trying to count all values that are less than Zero plus columns with a value of ".55".

I have tried =Count(IF(SumRange1,"<0",IF(SumRange1,"0.55",SumRange1))).

I get a value if I only use <0 argument but If I add the "0.55" I do not get any value. Nor do I get an answer with "0.55" by itself.

=COUNT(IF(SumRange1,"0.55",SumRange1)) Produces 0

=COUNTIF(SumRange1,"0.55") does provide the correct answer 1.

=(COUNTA(IF(SumRange1<>"0",IF(SumRange1<>".1",IF(SumRange1<>".35"
,IF(SumRange1<>".65",IF(SumRange1<>".9",IF(SumRange1<>"1"
,SumRange1)))))))) - Does not count negative numbers or .55 ( Also used Just COUNT on the front instead of COUNTA here as well with the same results.

thanks. -Neal

Replies
1
Views
629
Replies
2
Views
386
Replies
1
Views
185
Replies
3
Views
2K
Replies
12
Views
661

### Forum statistics

1,190,827
Messages
5,983,113
Members
439,824
Latest member
nellyc ### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?    1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option. Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com". Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button. Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button. Go back