Re: Crazy Excel 2003 Formula Question
- From: "Don Guillett" <dguillett1@xxxxxxxxxxxxx>
- Date: Fri, 9 Feb 2007 14:54:48 -0600
try incorporating this idea into your formula (starting with the second one)
=INDIRECT("g"&ROW(C1)*5)
--
Don Guillett
SalesAid Software
dguillett1@xxxxxxxxxxxxx
"Marilyn" <Marilyn@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:31E36E7E-98CD-40C5-8FB5-D28E7C71DEFB@xxxxxxxxxxxxxxxx
I have an Excel file where I'm using a 3D formula that calculates numbers
from 4 different sheets. All of the sheets are formatted the same so the
cell numbers are in the same position just different cells. My Problem is
this when I use Auto fill to copy the formula it does not pick up the
pattern. The numbers I'm adding from the 4 sheets have 4 blank cells in
between. for example =Sum(sheet 1:sheet4 A2!) and the next one is
=Sum(sheet1:sheet4 A6!).
Is there a combination I could use so that it skips 4 cells and then adds
it?
thanks,
.
- Prev by Date: Re: VB Script: Code for "Sheets in selection"
- Next by Date: Re: 2007 Opening Files Issue
- Previous by thread: Re: VB Script: Code for "Sheets in selection"
- Next by thread: Re: Crazy Excel 2003 Formula Question
- Index(es):
