|
|
#5
09-22-2023, 04:50 AM
|
|||
|
|||
I feel I am progressing here, a little.
I can use INDIRECT within SUBTOTAL(105,xxx) to get the results I'm looking for but all the workbooks still need to be open. Haven't yet figured out how to use SUMPRODUCT to do the same. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 When inserting row in table, how do I adjust cell reference to new row
|
Peterson | Excel Programming | 1 | 01-16-2022 01:06 PM |
| Find/Replace a cell with external reference | John Moses | Excel | 1 | 01-03-2020 05:52 AM |
|
Using Cell Values in Active Sheet to Populate Path to External Reference Link
|
wowcrofty | Excel | 4 | 12-19-2016 12:29 PM |
|
Reference Word Table Cell Using Offset?
|
wlcdo2 | Word VBA | 2 | 06-19-2016 08:53 PM |
|
Assign the value of a cell as a cell reference of another cell in Excel 2010 - How to?
|
bharathkumarst | Excel | 7 | 10-13-2014 10:25 AM |
Windows 10 
Office 2021
Threaded Mode