Posted to microsoft.public.excel.worksheet.functions

Picman

external usenet poster

Posts: 70

sum of more than 30 non-adjacent cells

I have a column with hundreds of populated cells, and I would like to add up
the sum of more than 30 of these cells. The problem is that they are not
adjacent to each other and the Excel SUM function seems to limit the number
of arguments to 30. Is there a way around this?

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
adjacent cells?	[email protected]	Excel Worksheet Functions	1	January 22nd 08 01:40 AM
Yes or No for adjacent cells	JKWParrott	Excel Worksheet Functions	3	October 3rd 07 01:57 AM
By selecting cells adjacent to cells tally sheet	tom	Excel Worksheet Functions	2	September 20th 06 07:09 PM
How do I fill (copy) nonadjacent cells to adjacent cells?	BuckyGeorge	Excel Discussion (Misc queries)	2	December 22nd 05 04:18 AM
selecting non adjacent cells	fran	Excel Worksheet Functions	4	April 25th 05 12:54 AM

All times are GMT +1. The time now is 03:19 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us