Worksheet defined cell sums

BobBridges · #3 06-17-2014, 08:54 AM

The syntax if you already knew the sheet names would be like this:

Code:

=SheetA!H2+SheetB!H2

Since you don't know the sheet names to plug in, you have to get them from C2 and C4, where the user put in the sheet names, and you have to construct a reference using the INDIRECT function, like this:

Code:

=INDIRECT(C2&"!H2")+INDIRECT(C4&"!H2")

The INDIRECT function takes a character string and interprets it as a cell reference, you see. Does this make sense to you?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
getting the worksheet name in a cell	derohanes	Excel	9	02-14-2013 01:29 PM
Help with SUMs in tables	mhurford	Word Tables	1	09-02-2012 03:06 AM
Range.Information(wdStartOfRangeRowNumber): Application-defined or Object-defined err	tinfanide	Excel Programming	2	06-09-2012 10:19 AM
Cell formating on Protected worksheet	AHB	Excel Programming	2	02-27-2012 10:25 AM
click a cell to go to a worksheet	victor	Excel	0	10-27-2006 02:57 PM