Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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, |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel formula question | Excel Discussion (Misc queries) | |||
Excel nested IF formula question | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Question about Excel 2003 | Excel Discussion (Misc queries) | |||
EDIT FORMULA BAR in excel 2003? why not? where is it? | Excel Worksheet Functions |