help to count items in array

[Aivars]

Hello,
Excel 2000 win 2000

I need to count how many items there are in a named array. This named
array consists of strings. It can be done using =COUNTA(Array_Name).
The problem is that this array name is returned in a worksheet cell
and the counta formula (in other cell) evaluate it as text, not as
named array name. Therefore, the count function on a worksheet looks
like this: =COUNTA("Array_Name") and it evaluates to 1. How to get rid
of these quotes inside parenthesis so that the formula should read:
=COUNTA(Array_Name)?
thanks in advance

Aivars

 

[Harlan Grove]

I need to count how many items there are in a named array. This named
array consists of strings. It can be done using =COUNTA(Array_Name).
The problem is that this array name is returned in a worksheet cell
and the counta formula (in other cell) evaluate it as text, not as
named array name. Therefore, the count function on a worksheet looks
like this: =COUNTA("Array_Name") and it evaluates to 1. How to get rid
of these quotes inside parenthesis so that the formula should read:
=COUNTA(Array_Name)?

=COUNTA(INDIRECT("Array_Name"))

 

[Aivars]

Thanks, Harlan,
Your formula returns 1. Should be e.g., 4
Array_Name={"a";"b";"c";"d"}