Thread: [Solved] Use of & to include a cell in a reference to an external Excel table
View Single Post
 
Old 09-22-2023, 04:50 AM
Rog7 Rog7 is offline Windows 10 Office 2021
Novice
  
Join Date: Sep 2023
Location: London
Posts: 4
Rog7 is on a distinguished road
Default
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.
Reply With Quote