Posted to microsoft.public.excel.misc

Posts: n/a

How to indicate in formula to choose the entire column starting from a specified cell?

How would you indicate in a formula for Excel to choose an entire
column? Say, for example I want to sum up all the values in column C
starting from C4?

Also, how would I indicate to Excel to sum up values excluding a few?
Say I want to sum up columns C2 to C12 but not C10 and C5.

Thank you!

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
Help with copying dynamic column selected based on remote cell value and dynamic formula fill	ers	Charts and Charting in Excel	0	March 1st 06 01:05 AM
Need to Improve Code Copying/Pasting Between Workbooks	David	Excel Discussion (Misc queries)	1	January 6th 06 03:56 AM
Possible Lookup Table	Karen	Excel Worksheet Functions	5	June 8th 05 09:43 PM
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 07:48 PM
GET.CELL	Biff	Excel Worksheet Functions	2	November 24th 04 07:16 PM

All times are GMT +1. The time now is 04:10 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us