#REF error in named formula

[Gene]

I have several worksheets in a workbook. I have ABX and XLNX as the first
and last worksheets. I have incorporated ABX:XLNX!J14 to reference cells in
each worksheet in a named formula. I get a #REF error. I put =ABX:XLNX!J14 in
a cell by itself and get the same error. I can't find anything wrong with
the reference

 

[Mike H]

Gene,

as pointed out in your post =ABX:XLNX!J14 would be a reference to sheet
ABX:XLNX cell J14 except that it would ne an liiegal sheet name because of
the colon.

Maybe you want to sum J14 in every sheet, in which case the correct syntax is
=SUM(ABX:XLNX!J14)

where ABX is the first sheet and XLNX is the last.

Mike

 

[Dave Peterson]

Check your other posts, too.

I have several worksheets in a workbook. I have ABX and XLNX as the first
and last worksheets. I have incorporated ABX:XLNX!J14 to reference cells in
each worksheet in a named formula. I get a #REF error. I put =ABX:XLNX!J14 in
a cell by itself and get the same error. I can't find anything wrong with
the reference