Forum Discussion

Popeye2015's avatar
Popeye2015
Copper Contributor
Aug 12, 2023

Excel

Lets say you fill cells vertically, what is the function used for totaling the number of cells?

4 Replies

    • Popeye2015's avatar
      Popeye2015
      Copper Contributor
      That didn't work after all.
      Here's the cells:
      14
      6
      3
      =CountC(C168:C171)
      This array is in the C column
      • OliverScheurich's avatar
        OliverScheurich
        Gold Contributor

        Popeye2015 

        There isn't a formula COUNTC in Excel. The formula is COUNTA. Or ANZAHL2 in german. 

        =COUNTA(C168:C171)