I'm trying to understand the following formula...
{=COUNT(TRANSPOSE(INDIRECT(ADDRESS(2+3*ROW(INDIRECT("1:75")),3))))}
If we take a look at the evaluation prior to COUNT, an array of #VALUE! errors is returned.
If we then de-reference using N(), we get an array of numerical values, including zero's.
Question 1
-----------
Why is the function TRANSPOSE needed in the formula?
Question 2
-----------
Why doesn't the result of the formula equal 75, since the array returned is made up of numerical values, including zero's (or is it)?
Any help would be greatly appreciated!
{=COUNT(TRANSPOSE(INDIRECT(ADDRESS(2+3*ROW(INDIRECT("1:75")),3))))}
If we take a look at the evaluation prior to COUNT, an array of #VALUE! errors is returned.
If we then de-reference using N(), we get an array of numerical values, including zero's.
Question 1
-----------
Why is the function TRANSPOSE needed in the formula?
Question 2
-----------
Why doesn't the result of the formula equal 75, since the array returned is made up of numerical values, including zero's (or is it)?
Any help would be greatly appreciated!