t******a
发帖数: 30 | 1 This could be silly, but there is some formula/function in a cell that
puzzles me.
The formula is something like:
{=SUM(IF(ISNUMBER($B1864:$F1864),TRANSPOSE('TEMPLATE - Regression'!$I$20:$I$
24)*($B1864:$F1864),0))+'TEMPLATE - Regression'!$I$19}
The calculation itself is simple, it is a sum of product after transposing
some data. But what is that brackets doing there? I mean the {} at the
beginning and end. The results change if i delete the {}.
Thanks! | l****i
发帖数: 37 | 2 google array formula
I$
【在 t******a 的大作中提到】
: This could be silly, but there is some formula/function in a cell that
: puzzles me.
: The formula is something like:
: {=SUM(IF(ISNUMBER($B1864:$F1864),TRANSPOSE('TEMPLATE - Regression'!$I$20:$I$
: 24)*($B1864:$F1864),0))+'TEMPLATE - Regression'!$I$19}
: The calculation itself is simple, it is a sum of product after transposing
: some data. But what is that brackets doing there? I mean the {} at the
: beginning and end. The results change if i delete the {}.
: Thanks!
| t******a
发帖数: 30 | 3 Thank you!
【在 l****i 的大作中提到】
: google array formula
:
: I$
|
|
