Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas pulling from other tables
I am looking to write a formula on a summary sheet that will pull
totals from a data sheet. The problem is that the cells that contain the totals changes from month to month and based on how I sort the information. Is there a way to write the formula so it looks for the column/row names, rather than the cell. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulas and Pivot tables | Excel Discussion (Misc queries) | |||
pivot tables custom formulas | Excel Discussion (Misc queries) | |||
Lookup Tables and Formulas | Excel Worksheet Functions | |||
Formulas and Pivot Tables | Excel Discussion (Misc queries) | |||
Comparing tables in excel with formulas | Excel Discussion (Misc queries) |