A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

"cascading" formula



 
 
Thread Tools Display Modes
  #1  
Old November 16th, 2003, 03:36 AM
Kathy A
external usenet poster
 
Posts: n/a
Default "cascading" formula

I am summing a row of cells to calculate return mail over
a range of days. Each day's outgo number is multiplied by
a different return rate (this is vertical); each day's
incoming mail is a "slice" across a different point in
each day's outgo. This sum needs to be in column format
to link to another sheet which forecasts daily totals
across different types of mail. Is there any way when
dragging this formula down the column, that I can have it
include one additional column to the right with each row
down? (Other than changing the cell reference manually in
the formula bar, which is incredibly tedious...) There
has to be a way to automate this.
Thanks,
Kathy
  #2  
Old November 16th, 2003, 04:20 AM
Vasant Nanavati
external usenet poster
 
Posts: n/a
Default "cascading" formula

To keep it simple, let's say cell A1 contains the formula:

=B1

and when you drage it down, instead of:

=B2
=C2

etc., you want:

=C1
=D1

and so on.

Change the original formula in A1 from:

=B1

to:

=OFFSET($B$1,0,ROW()-ROW($A$1))

Dragging this formula down column A will give you the results you need. Be
careful, though; inserting rows and columns may mess up the references.
--

Vasant



"Kathy A" wrote in message
...
I am summing a row of cells to calculate return mail over
a range of days. Each day's outgo number is multiplied by
a different return rate (this is vertical); each day's
incoming mail is a "slice" across a different point in
each day's outgo. This sum needs to be in column format
to link to another sheet which forecasts daily totals
across different types of mail. Is there any way when
dragging this formula down the column, that I can have it
include one additional column to the right with each row
down? (Other than changing the cell reference manually in
the formula bar, which is incredibly tedious...) There
has to be a way to automate this.
Thanks,
Kathy



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


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


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.