formulasgoogle sheets
Column AE has dates
Column AG has text
I need to count how many rows have these occurrences:
I've been trying for a while, looking around the questions and answers, I got this, but it gives me an error:
=COUNTIF(AE3:AE124,"<"&TODAY()), isblank(AG3:AG124)
I'll describe the solution step by step:
=split(join(", ", filter(A2:A, len(A2:A))), ", ", False)
does this, by taking nonempty cells in the range A2:A (this is what filter is for), joining them using the same comma-space separator you have within cells, and then splitting by that separator (not by space or comma separately).
This is easy: just add transpose.
=transpose(split(join(", ", filter(A2:A, len(A2:A))), ", ", False))
This is only if you don't want the counts. unique does the job then.
=unique(transpose(split(join(", ", filter(A2:A, len(A2:A))), ", ", False)))
For this I would use query instead of unique:
=query(transpose(split(join(", ", filter(A2:A, len(A2:A))), ", ", False)),
"select Col1, count(Col1) group by Col1", 0)
Which says: group by name, and include the count of repetitions. The last argument "0" says the data has no header row, which it doesn't since we started with A2.
try this:
=QUERY('Interview Planning'!A:G; "select D, A, F, G where G = ''"; 1)
and also select column G end set it as plain text
https://docs.google.com/spreadsheets/d/
Best Answer
If you have multiple IFs, use
COUNTIFSinstead ofCOUNTIF.The format is: first range, criterion for it, second range, criterion for it, and so on.
The condition
"="means being empty, while"<>"would be "non-empty".