Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 211
Default Crazy Excel 2003 Formula Question

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,


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 211
Default Crazy Excel 2003 Formula Question

Hi Don,

I dont understand how to add your addition to my formula. Right now I have
=sum(sheet1:sheet4:!a6) should i add your like this: =sum(sheet1:sheet4:!a6,
=INDIRECT("g"&ROW(C1)*5).

thanks,


"Don Guillett" wrote:

try incorporating this idea into your formula (starting with the second one)
=INDIRECT("g"&ROW(C1)*5)

--
Don Guillett
SalesAid Software

"Marilyn" wrote in message
...
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,





  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 211
Default Crazy Excel 2003 Formula Question

All I want to do is tell Excel to sum the next 4 numbers when I use Auto Fill
to copy the original Formula which is =Sum(Sheet1:Sheet4!A1)

Any Suggestions?

Thanks,

"Marilyn" wrote:

Hi Don,

I dont understand how to add your addition to my formula. Right now I have
=sum(sheet1:sheet4:!a6) should i add your like this: =sum(sheet1:sheet4:!a6,
=INDIRECT("g"&ROW(C1)*5).

thanks,


"Don Guillett" wrote:

try incorporating this idea into your formula (starting with the second one)
=INDIRECT("g"&ROW(C1)*5)

--
Don Guillett
SalesAid Software

"Marilyn" wrote in message
...
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,





  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10,124
Default Crazy Excel 2003 Formula Question

Try it this way for the 2nd set -copied down. This is ONE line so correct
for word wrap. Send me your email address and I will send you a sample
workbook.

=SUM(SUMIF(INDIRECT("Sheet"&{2,3,4}&"!A"&ROW(A1)*4 ),"<0",INDIRECT("Sheet"&{2,3,4}&"!a"&ROW(A1)*4) ))

--
Don Guillett
SalesAid Software

"Marilyn" wrote in message
...
All I want to do is tell Excel to sum the next 4 numbers when I use Auto
Fill
to copy the original Formula which is =Sum(Sheet1:Sheet4!A1)

Any Suggestions?

Thanks,

"Marilyn" wrote:

Hi Don,

I dont understand how to add your addition to my formula. Right now I
have
=sum(sheet1:sheet4:!a6) should i add your like this:
=sum(sheet1:sheet4:!a6,
=INDIRECT("g"&ROW(C1)*5).

thanks,


"Don Guillett" wrote:

try incorporating this idea into your formula (starting with the second
one)
=INDIRECT("g"&ROW(C1)*5)

--
Don Guillett
SalesAid Software

"Marilyn" wrote in message
...
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,







Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Excel formula question bb Excel Discussion (Misc queries) 3 April 20th 06 04:11 AM
Excel nested IF formula question [email protected] Excel Discussion (Misc queries) 6 November 10th 05 06:11 PM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 03:01 PM
Question about Excel 2003 Jason Excel Discussion (Misc queries) 1 April 27th 05 04:53 PM
EDIT FORMULA BAR in excel 2003? why not? where is it? alnav89 Excel Worksheet Functions 2 April 26th 05 08:02 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"