Posted to microsoft.public.excel.worksheet.functions

Mopechicken Mopechicken is offline

external usenet poster

Posts: 2

formula to sum the prior 12 cells regardless of added columns?

I need to sum the preceding 12 cells in a row within excel - regardless of
the fact that some columns will be added in front of this cell with the
formula. I want the formula to "float" just not sure how to accomplish it?

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
Calculating only non-empty cells...	Jay	Excel Worksheet Functions	9	September 22nd 06 03:20 AM
Is it possible?	DakotaNJ	Excel Worksheet Functions	25	September 18th 06 09:30 PM
Match then lookup	Tenacity	Excel Worksheet Functions	9	December 3rd 05 05:30 AM
Formula Problem - interrupted by #VALUE! in other cells!?	Ted	Excel Worksheet Functions	17	November 25th 05 05:18 PM
trying to create an (almost) circular formula between cells and data validated cells with lists	KR	Excel Worksheet Functions	0	May 12th 05 07:21 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us