You can pass "<>"
(including the quotes) as the parameter for criteria
. This basically says, as long as its not empty/blank, count it. I believe this is what you want.
=COUNTIF(A1:A10, "<>")
Otherwise you can use CountA
as Scott suggests
More Related Contents:
- ArrayFormula of Average on Infinite Truly Dynamic Range in Google Sheets
- Conditional formatting based on another cell’s value
- Google Sheets importXML Returns Empty Value
- Get the last non-empty cell in a column in Google Sheets
- How to stop / freeze / pause volatile RAND / RANDBETWEEN / RANDARRAY?
- How to SUM duration in Google Sheets?
- ArrayFormula and “AND” Formula in Google Sheets
- ARRAY_LITERAL, an Array Literal was missing values for one or more rows
- Query is ignoring string (non numeric) value
- Repeat whole row N times based on column value in Google Sheets
- I get Formula parse error with all formulas
- IMPORTXML and right XPath from Bloomberg price [duplicate]
- What factors determine the memory used in lambda functions?
- How to list all permutations without repetition?
- How to use arrayformula with formulas that do not seem to support arrayformulas?
- Repeat each row N times in Google Sheets
- How to create all possible pair combinations without duplicates in Google Sheets?
- Col BY causing parse error in Google sheets query
- How to make a range repeat n-times in Google SpreadSheet
- In ARRAY_LITERAL, an Array Literal was missing values for one or more rows – indirect formula error in google spreadsheet
- QUERY and order by the first date of column
- Apps Script: how to get hyperlink from a cell where there is no formula
- How would I import YouTube Likes and Dislikes and a ratio from YouTube onto Google Sheets? [closed]
- How to Autofill last row with formula, when data is received from IFTTT on the last row?
- How to compare dates or date against today with query on google sheets?
- Download link for Google Spreadsheets CSV export – with Multiple Sheets
- Stacking multiple columns on to one?
- New Google spreadsheet Concatenate limit 50000 characters
- Google Sheet use Importxml error could not fetch url [duplicate]
- How to Print sheet/range using .gs script in Google Sheets?