View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Héctor Miguel Héctor Miguel is offline
external usenet poster
 
Posts: 434
Default Another Array Mystery

hi, Jerry !

- while counta(... includes any non-empty cells, count(... *can only* count numbers
- when the mmult(... formula is written in an array-range, the numbers "shows-up" (but...)
- while in a single cell (within the array-range) you press {F2}+{F9}, evaluation shows only "error-values" (so...)

one way to use count(... (in a CSE formula) to count "numbers" (while a single cell-formula shows errors),
could it be: COUNT(--ISERROR(formula))

hth,
hector.

__ OP __
I have an array formula, that returns a 12x1 array of numbers.
If I return that array to a range, then =COUNT(range) returns 12, but =COUNT(formula) returns zero
while =COUNTA(formula) returns 12.
All formulas [with the obvious exception of =COUNT(range)] are array entered.
What gives?

Jerry

The formula is
MMULT({1,0}+{-1,1}/(1+(B$31/$D$2:$D$13)^$A32),INDEX(LINEST($C$2:$C$13,{1,0}+{-1,1}/(1+(B$31/$D$2:$D$13)^$A32),0),1,{2;1}))-$C$2:$C$13