| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking sumif formula to the data
Is there a way to link a sumif formula to the data on a different worksheet
that makes up the sum of the formula. If I click on the cell that contains the sum, the data that makes up that sum will show up on a different worksheet. Don't know if possible. Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Linking sumif formula to the data
Certainly, you can address ranges in other worksheets, as in:
=sumif(sheet2!A:A,"criteria",sheet3!B:B) Does that help? Fred "Jarod" wrote in message ... Is there a way to link a sumif formula to the data on a different worksheet that makes up the sum of the formula. If I click on the cell that contains the sum, the data that makes up that sum will show up on a different worksheet. Don't know if possible. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking data that won't change when original formula changes | Excel Discussion (Misc queries) | |||
| Problem with SUMPRODUCT(SUMIF(INDEX formula linking to external fi | Excel Worksheet Functions | |||
| Basic formula for linking data | Excel Worksheet Functions | |||
| how do i use sumif when linking worksheet | Excel Discussion (Misc queries) | |||
| how do i use sumif when linking worksheet | Excel Discussion (Misc queries) | |||
Linear Mode
