Posted to microsoft.public.excel.misc

Confused_in_Houston[_2_] Confused_in_Houston[_2_] is offline

external usenet poster

Posts: 15

Summing Contiguous Values in a Column?

I have groupings of data in column A. Each group is obviously continguous.
The data grouping are separated by a single blank cell in the column. I
would like to sum the values in each group.

What I have:

A
1000
500
300
200

1000
400
100

1000
1000

What I'd like:

A B
1000
500
300
200
2000
1000
400
100
1500
1000
1000
2000

thanks!

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
summing non-contiguous array cells	WRC	Excel Worksheet Functions	10	November 5th 07 10:26 PM
summing last values in column	gotta know	Excel Worksheet Functions	11	December 27th 06 01:51 PM
Summing non contiguous cells	Millie	Excel Discussion (Misc queries)	4	August 10th 06 10:23 PM
summing non contiguous ranges	valaor	Excel Discussion (Misc queries)	6	March 22nd 06 04:17 PM
Summing non-contiguous cells	Cheryl	Excel Worksheet Functions	6	April 26th 05 03:04 AM

All times are GMT +1. The time now is 12:38 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us