Getting a number of cells summed in a =SUM formula

google-sheets

28 观看

1回复

1 作者的声誉

I just summed up a some cells using the =SUM formula.

I have to multiply the number of cells being summed by 6, so my question is:

Is there any way for me to get another cell to display the amount of cells being summed in the =SUM formula?

作者: Daníel Ágúst Ágústsson 的来源 发布者: 2017 年 12 月 27 日

回应 1


2

7501 作者的声誉

Try this in whatever cell you need the value :

=count(A1:A)*6
作者: Ed Nelson 发布者: 2017 年 12 月 27 日
来自类别的问题 :
32x32