help to count items in array

A

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
 
H

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)?
Click to expand...

=COUNTA(INDIRECT("Array_Name"))
 
A

Aivars

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