[Solved] Count of cells with numbers

[katintn]

have a row of number containing numbers with some cells empty. Am looking for formula to give me a count of cells within a range that have #'s in it and leaving out the blank cells.. Not sure if Countif or Sumif is what I'm looking for. I think (cell range >0 ) but not too sure which function to use and how formula should be laid out. if someone could help I would greatly appreciate it.... Thanks

[MrProgrammer]

Am looking for formula to give me a count of cells within a range that have #'s in it and leaving out the blank cells.

When viewing a sheet, menu View → Value Highlighting shows which cells have values that Calc can recognize as a number. Those values are shown in blue. Values shown in green are the result of a formula. Some formulas return numbers; some don't; it depends on the formula. Values shown in black are non-formula cells which are not recognized as numbers, that is, they are text. Disable View → Value Highlighting when you are not using the feature since it will prevent Calc from displaying cells in other colors.

Function COUNT(range) (not COUNTIF) tells how many cells in a cell range have numeric values (from a formula or not). For example =COUNT(A2:Z2) is the count of numbers in columns A through Z of the second row. COUNT ignores empty cells and text cells.

If you need any additional assistance attach a spreadsheet demonstrating the difficulty (remove confidential information then use Post Reply, not Quick Reply, and don't attach a picture instead of the spreadsheet itself). I will not help further unless you attach a spreadsheet document. You will need to explain which sheet and which range of cells you need help with. You also need to say which sheet and which cell should contain the count of numbers.

If this solved your problem please go to your first post use the Edit ✏️ button and add [Solved] to the start of the Subject field. Select the green checkmark icon at the same time.

[Tutorial] Ten concepts that every Calc user should know

[katintn]

THANK YOU SO MUCH.... I was trying to make it more complicated than need be.... so appreciate you!!!!!