Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenThu, 03 Oct 2019 03:36:51 +0200Calc: calculate number of cells containing digits, rather than actual digits within each cell, in Calc?https://ask.libreoffice.org/en/question/211102/calc-calculate-number-of-cells-containing-digits-rather-than-actual-digits-within-each-cell-in-calc/Mac OS Mojave, LO 6.2.5.2
Let's say I have a spreadsheet containing 4 cells, in each cell is a number, let's say 1,2,3 & 4 for each respective cell.
How do I calculate the sum of the number of cells with numbers in them (4), rather than the total of the numbers within the cells, to return the result **4**, instead of **10** (as a regular **SUM** formula would produce)?appreciatethehelpThu, 03 Oct 2019 03:36:51 +0200https://ask.libreoffice.org/en/question/211102/