#REF error in named formula

  • Thread starter Thread starter Gene
  • Start date Start date
G

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
 
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
 
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
Click to expand...
 
Back
Top