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$
|
|