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?
OliverScheurich
Aug 12, 2023Gold Contributor
- Popeye2015Aug 12, 2023Copper ContributorThat didn't work after all.
Here's the cells:
14
6
3
=CountC(C168:C171)
This array is in the C column- OliverScheurichAug 12, 2023Gold Contributor
There isn't a formula COUNTC in Excel. The formula is COUNTA. Or ANZAHL2 in german.
=COUNTA(C168:C171)
- Popeye2015Aug 12, 2023Copper ContributorThank you