Posted to microsoft.public.excel.misc

Hilton

external usenet poster

Posts: 35

Aggregate query

I have 2 columns of numbers i.e delay and count
Delay Count
0.01 10
0.03 11
0.81 8
1,01 12
1,08 9
2.1 11

I would like to sum 2nd column according to the ranges eg
0 -.0.99 29
1 - 1.99 21
2.- 2.99 11

Is there a way to do this without highlighting the range and summing
manually?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how do I aggregate dates	Johnopp	Excel Discussion (Misc queries)	5	March 5th 06 10:26 PM
Aggregate Data from a column in a cell	Enron	Excel Worksheet Functions	0	February 20th 06 04:36 PM
show aggregate total in pie chart	ecav	Charts and Charting in Excel	1	September 28th 05 07:32 AM
aggregate calculations	[email protected]	Excel Discussion (Misc queries)	0	May 26th 05 04:32 PM
How to aggregate values in a database	Frank	Excel Worksheet Functions	0	March 16th 05 01:15 PM

All times are GMT +1. The time now is 11:00 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us