| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please help, how to enter a formula into sheet 2 using data in she
Sorry if this post went through earlier, having some issues on my end.
I have a list of data in sheet 1 of a workbook and I would like to create a data generator on sheet 2 of the workbook using the data in sheet one. I have the formula which works in sheet 1 but when I move it to sheet 2 the formula is no longer valid. The formula is =SUMIF(B11:B2153,"AC",C11:C2153). Is there a way to move these formulas to other sheets in a workbook using data on different pages? Thanks in advance for any help. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Please help, how to enter a formula into sheet 2 using data in she
Yes, just precede the cell addresses with the sheet name, as in:
=SUMIF(Sheet1!B11:B2153,"AC",Sheet1!C11:C2153) Regards, Fred "skippy0070" wrote in message ... Sorry if this post went through earlier, having some issues on my end. I have a list of data in sheet 1 of a workbook and I would like to create a data generator on sheet 2 of the workbook using the data in sheet one. I have the formula which works in sheet 1 but when I move it to sheet 2 the formula is no longer valid. The formula is =SUMIF(B11:B2153,"AC",C11:C2153). Is there a way to move these formulas to other sheets in a workbook using data on different pages? Thanks in advance for any help. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Please help, how to enter a formula into sheet 2 using data in she
You will need to add the Sheet Name to the range references in your formula:
=SUMIF('Sheet1'!B11:B2153,"AC",'Sheet1'!C11:C2153) HTH Elkar "skippy0070" wrote: Sorry if this post went through earlier, having some issues on my end. I have a list of data in sheet 1 of a workbook and I would like to create a data generator on sheet 2 of the workbook using the data in sheet one. I have the formula which works in sheet 1 but when I move it to sheet 2 the formula is no longer valid. The formula is =SUMIF(B11:B2153,"AC",C11:C2153). Is there a way to move these formulas to other sheets in a workbook using data on different pages? Thanks in advance for any help. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Please help, how to enter a formula into sheet 2 using data in
That works great, thank you.
"Elkar" wrote: You will need to add the Sheet Name to the range references in your formula: =SUMIF('Sheet1'!B11:B2153,"AC",'Sheet1'!C11:C2153) HTH Elkar "skippy0070" wrote: Sorry if this post went through earlier, having some issues on my end. I have a list of data in sheet 1 of a workbook and I would like to create a data generator on sheet 2 of the workbook using the data in sheet one. I have the formula which works in sheet 1 but when I move it to sheet 2 the formula is no longer valid. The formula is =SUMIF(B11:B2153,"AC",C11:C2153). Is there a way to move these formulas to other sheets in a workbook using data on different pages? Thanks in advance for any help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Enter date, then pull data from another sheet | Excel Discussion (Misc queries) | |||
| Using TAB vs ENTER for data entry in a protected sheet | Excel Worksheet Functions | |||
| Enter data on one sheet duplicate on another? | Excel Discussion (Misc queries) | |||
| enter data on 1 sheet and make it enter on next avail row on 2nd s | Excel Discussion (Misc queries) | |||
| Auto-Enter Data from One Sheet to Another | Excel Discussion (Misc queries) | |||
Hybrid Mode
