# Countif with negative numbers

#### blaic

##### New Member
I am a first time user. I am grateful that you there is a place in the world for people like us, the excel misfits.

I am working on a case and need your help. I need to count the number of occurences of each category, i.e. between 0 and -1, 0 and -2, 0 and -3, 0 and 1, 0 and 2, 0 and 3 of the following data:

-2.01646833
-1.614184032
-0.458823528
0.422983654
0.91216136
-1.041331191
-1.203854048
1.155141077
-0.954437783
-0.4749149
1.705465996
1.785922856
-0.8643261
-0.688930146
-0.450777842
0.067364334
-0.22228036
-0.391239766
-0.460432665
-0.328483415
1.068247668
-1.137879423
0.138166371
-0.312392043
-0.770996143
0.11563845
0.524359297
0.571024276
1.579953295
1.089166452
1.924308655
0.775384699
0.884806028
-0.463650939
-0.626173796
0.699755251
0.886415165
1.122958333
0.336090245
-0.569853994
-0.927082451
0.046445551
0.178394801
-2.011640919

I will be using 6 different columns to capture each segment. Can you help?

Thank you.

### Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
You can use a sequence of counti -

=COUNTIF(\$A:\$A,"<=0")-COUNTIF(\$A:\$A,"<-1")

to get the count of 0:-1 inclusive.

Replies
6
Views
146
Replies
2
Views
307
Replies
4
Views
396
Replies
16
Views
1K
Replies
3
Views
202

1,218,845
Messages
6,144,807
Members
450,567
Latest member
Mplz

### 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