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

njbisp

New Member
Joined
Oct 18, 2006
Messages
5
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().

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
use the histogram tool (tools | data analysis). you need the analysis toolpac addin activated to use this (tools | addins)
 

tusharm

MrExcel MVP
Joined
May 28, 2002
Messages
11,029
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

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
"...not that there's anything wrong with it..."

I guess the OP did ask for a formula :)
 

njbisp

New Member
Joined
Oct 18, 2006
Messages
5
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
Joined
May 28, 2005
Messages
49,439
Office Version
  1. 365
Platform
  1. Windows
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
 

Forum statistics

Threads
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?

Disable AdBlock

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
Top