Use of & to include a cell in a reference to an external Excel table

		Microsoft Office Forums > Microsoft Excel > Excel
Use of & to include a cell in a reference to an external Excel table

FAQ

Mark Forums Read

Thread Tools

Display Modes

09-22-2023, 04:50 AM

Rog7

Windows 10 Use of & to include a cell in a reference to an external Excel table

Office 2021

Novice

Join Date: Sep 2023

Location: London

Posts: 4

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.

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:43 PM.