Forum Discussion
Popeye2015
Aug 12, 2023Copper Contributor
Excel
Lets say you fill cells vertically, what is the function used for totaling the number of cells?
Popeye2015
Aug 12, 2023Copper Contributor
That didn't work after all.
Here's the cells:
14
6
3
=CountC(C168:C171)
This array is in the C column
Here's the cells:
14
6
3
=CountC(C168:C171)
This array is in the C column
OliverScheurich
Aug 12, 2023Gold Contributor
There isn't a formula COUNTC in Excel. The formula is COUNTA. Or ANZAHL2 in german.
=COUNTA(C168:C171)