# Help!! My wrist are in pain from typing to figure this out

#### njbisp

##### New Member
I have 1 column with numbers that range from 1.00 to -5.00 with about 160 rows. I want to count the number of cells that contain 1.00 to 0.00 and total in a cell at bottom of page, another that totals -0.01 to 1.00, another that totals -1.01 to -2.00 and so on.

Is there a formula to do this, maybe even highlight cells in each group with a cell color.

Any assistance appreciated.

### Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

##### MrExcel MVP
use the histogram tool (tools | data analysis). you need the analysis toolpac addin activated to use this (tools | addins)

#### tusharm

##### MrExcel MVP
Re: Help!! My wrist are in pain from typing to figure this o

For an alternative to Paddy's suggestion (not that there's anything wrong with it), check out XL help for the FREQUENCY function.

I have 1 column with numbers that range from 1.00 to -5.00 with about 160 rows. I want to count the number of cells that contain 1.00 to 0.00 and total in a cell at bottom of page, another that totals -0.01 to 1.00, another that totals -1.01 to -2.00 and so on.

Is there a formula to do this, maybe even highlight cells in each group with a cell color.

Any assistance appreciated.

##### MrExcel MVP
"...not that there's anything wrong with it..."

I guess the OP did ask for a formula

#### njbisp

##### New Member
I am confused. Do not know much about this yet. Been trying all suggestions but not as experienced...yet! I am determined and really appreciate all of your input.

#### Peter_SSs

##### MrExcel MVP, Moderator
njbisp

Here is yet another way you might consider. Formula in E2 (copied down):
=COUNTIF(A:A, ">="&D2)-SUM(E\$1:E1)
Mr Excel.xls
ABCDEF
1-0.04RangeBottom of RangeCount
2-1.821.00 to 003
3-1.53-0.01to -1-14
4-3.97-1.01 to -2.00-25
5-0.79-2.01 to -3.00-32
6-0.1-3.01 to -4.00-42
7-4.02-4.01 to -5-53
8-2.76
90.58
100.39
11-0.04
12-1.31
13-4.95
14-3.02
15-4.1
16-1.72
170.77
18-2.93
19-1.62
20
Count Groups

Replies
11
Views
630
Replies
0
Views
225
Replies
9
Views
307
Replies
7
Views
126
Replies
1
Views
292

1,136,621
Messages
5,676,852
Members
419,656
Latest member
lironprofit

### 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.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

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

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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