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