a*******o
发帖数: 280 | 1 What does this excel expression mean?
SUM(BB:CC!B27)+B26
Please help me understand it.
BaoZi for anybody providing meaningful answers.
Thanks so much. |
c****0
发帖数: 14490 | 2 you have an excel sheet named "BB"..."CC"
what is calculated is the sum of cell"B26" from each of those spreed sheet
and then add cell "B26" from current sheet.
【在 a*******o 的大作中提到】
: What does this excel expression mean?
: SUM(BB:CC!B27)+B26
: Please help me understand it.
: BaoZi for anybody providing meaningful answers.
: Thanks so much.
|
c****0
发帖数: 14490 | 3 there could be excel sheets named whatever between sheet"BB" and "CC", they
will be all included in the calculation. |
a*******o
发帖数: 280 | 4 Thanks. Solved.
It is tab physically between BB and CC.
Transferred BaoZi to you.
they
【在 c****0 的大作中提到】
: there could be excel sheets named whatever between sheet"BB" and "CC", they
: will be all included in the calculation.
|
z**********i
发帖数: 12276 | 5 我现在每天就只有excel。
【在 a*******o 的大作中提到】
: What does this excel expression mean?
: SUM(BB:CC!B27)+B26
: Please help me understand it.
: BaoZi for anybody providing meaningful answers.
: Thanks so much.
|
c****0
发帖数: 14490 | 6 谢谢包子：O(∩_∩)O
【在 a*******o 的大作中提到】
: Thanks. Solved.
: It is tab physically between BB and CC.
: Transferred BaoZi to you.
:
: they
|
