| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Worksheet references another tab in formula
Worksheet contains Tabs: report and one for each month.
In the report tab Cell A2 contains the 3 letter month. Cell a2 is named "month". Formula in cell A4 needs to be the total of widgets for the month in cell A2. How do you reference the month in cell A2 in a formula to bring the totals from that tab to the report cell A4,ie. the formula in A4 changes to whatever month is in A2? A1 A2 A3 A4 Month= JUL Total= =sumif(Monthtab! A2:A10,"Widgets",Monthtab!B2:B10) Thanks.... |
|
#2
|
|||
|
|||
|
Try:
=SUMIF(INDIRECT("'"&A2&"'!A2:A10"),"Widgets",INDIR ECT ("'"&A2&"'!B2:B10")) HTH Jason Atlanta, GA -----Original Message----- Worksheet contains Tabs: report and one for each month. In the report tab Cell A2 contains the 3 letter month. Cell a2 is named "month". Formula in cell A4 needs to be the total of widgets for the month in cell A2. How do you reference the month in cell A2 in a formula to bring the totals from that tab to the report cell A4,ie. the formula in A4 changes to whatever month is in A2? A1 A2 A3 A4 Month= JUL Total= =sumif(Monthtab! A2:A10,"Widgets",Monthtab!B2:B10) Thanks.... . |
|
#3
|
|||
|
|||
|
Thanks a million!!!!!!
-----Original Message----- Try: =SUMIF(INDIRECT("'"&A2&"'!A2:A10"),"Widgets",INDI RECT ("'"&A2&"'!B2:B10")) HTH Jason Atlanta, GA -----Original Message----- Worksheet contains Tabs: report and one for each month. In the report tab Cell A2 contains the 3 letter month. Cell a2 is named "month". Formula in cell A4 needs to be the total of widgets for the month in cell A2. How do you reference the month in cell A2 in a formula to bring the totals from that tab to the report cell A4,ie. the formula in A4 changes to whatever month is in A2? A1 A2 A3 A4 Month= JUL Total= =sumif(Monthtab! A2:A10,"Widgets",Monthtab!B2:B10) Thanks.... . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
| Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
| Creating a formula that references other sheets | Excel Worksheet Functions | |||
| Help with macro formula and variable | Excel Worksheet Functions | |||
| Can I use a formula to get the worksheet name into a cell? | Excel Worksheet Functions | |||
Hybrid Mode
