Range name Problem

[Landmine]

I have created a range name XYZ23 refering to a column of data in sheet1. On
sheet 2 I typed XYZ23 in cell A3. Why does =COUNT(A3) typed in B3 return a 0
when =COUNT(XYZ23) return the correct count?

 

[Frank Kabel]

Hi
use
=COUNT(INDIRECT(A3))

 

[Don Guillett]

try countA

 

[Landmine]

I tried this and get the same result 0. Any suggestions?

 

[Frank Kabel]

Hi
what is exactly in A3 and how have you defined your name

 

[Landmine]

Thanks for your reply. in cell A3 is the text XYZ23. No formatting applied.
It appears through formula editing it thinks this is a constant and is not
referencing my name XYZ23 which is a lengthy offset string. Listed below:

=OFFSET(Sheet1!$H$1,MATCH(Sheet2!$A$4,Sheet1!$C:$C,1)-1,0,MATCH(Sheet2!$A$4,Sheet1!$C:$C,0)-MATCH(Sheet2!$A$4,Sheet1!$C:$C,1)-1,1)

It appears I need a method to match the range name XYZ23 to the text I typed
in cell A3.

Thanks