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
google sheets - How to count number of non-blank cells (cells that contain text)? - Stack Overflow
How to count cells with any text in them.
Counta should do the trick
More on reddit.comUsing countif to determine a specific text result
How to COUNTIF letter/word is in cell
Does Coefficient work with both Google Sheets and Excel?
What is Coefficient's AI Sheets Assistant?
What is Coefficient?
Im stuck at one point. I'm trying to use countif formula to determine how many times a word of a string of words appear but sometimes there are two entries in a single cell and I have separated them by a slash. The countif formula doesn't seem to capture it. I'll show an example attached to this.
Avenger Iron Man comes two times and Avenger Iron Man Red comes two times but somehow the countif doesn't capture the word after the slash.
(for your information this is just a basic example. My actual spreadsheet is massive and has a lot of entries separated by slash. 99 percent of the time I can filter by using a unique word. But when similar words come then it just fails). Any help would be appreciated.
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
COUNTIF function will only count cells that contain numbers in your specified range.
COUNTA(range) will count all values in the list of arguments. Text entries and numbers are counted, even when they contain an empty string of length 0.
Example: Function in A7 =COUNTA(A1:A6)
Range:
A1 a
A2 b
A3 banana
A4 42
A5
A6
A7 4 -> result
Google spreadsheet function list contains a list of all available functions for future reference https://support.google.com/drive/table/25273?hl=en.
Hey r/googlesheets, long time listener, first time caller, here with kind of a dumb question.
I'm making a guest list. First name is column A, last name is column B, "Plus one?" is column C, with a dropdown menu. What function would I use to count all the cells in column A that have text in them. Ultimately, I want a cell with the total number of guests.
Thanks in advance.
Counta should do the trick
Posting your data can make it easier for others to help you, but it looks like your submission doesn't include any. If this is the case and data would help, you can read how to include it in the submission guide. You can also use this tool created by a Reddit community member to create a blank Google Sheets document that isn't connected to your account. Thank you.
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.