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

[njbisp]

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.

 

[PaddyD]

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

 

[tusharm]

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.

 

[PaddyD]

"...not that there's anything wrong with it..."

I guess the OP did ask for a formula

 

[njbisp]

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]

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
	A	B	C	D	E	F
1	-0.04		Range	Bottom of Range	Count
2	-1.82		1.00 to 0	0	3
3	-1.53		-0.01to -1	-1	4
4	-3.97		-1.01 to -2.00	-2	5
5	-0.79		-2.01 to -3.00	-3	2
6	-0.1		-3.01 to -4.00	-4	2
7	-4.02		-4.01 to -5	-5	3
8	-2.76
9	0.58
10	0.39
11	-0.04
12	-1.31
13	-4.95
14	-3.02
15	-4.1
16	-1.72
17	0.77
18	-2.93
19	-1.62
20
Count Groups