| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding what makes up a summed cell in Excel
If I have a number of spreadsheets I am summing together, I use the formula that will sum the same cell on a range of tabs. Some of those tabs may not have any data in the cell I am summing. From the sum formula, is there a way to find out which tabs do have data that make up the sum without having to manually go through each tab?
Thanks for any help you can provide! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using cell color in conditional format makes Excel unstable | Excel Programming | |||
| Finding the location of what was summed | Excel Worksheet Functions | |||
| Recording Macro - Excel makes reference to a specific cell | Excel Programming | |||
| Making cell reference absolute makes cell format text | Excel Worksheet Functions | |||
| Summed Cell won't update as I add data into the cell range... | Excel Worksheet Functions | |||
Threaded Mode
