How can i count active projects in google sheets?

Deedmunkee 0
Viewed 33

I want to count how many active projects from for ex 01/01/2022 to 07/01/2022 if there's an end date then the projected is ended. If not then its still ongoing so don't count it.

date countif count filter google-sheets
1 Answers

try:

=COUNTA(IFNA(FILTER(A:A; B:B>="01/01/2022"; B:B<="07/01/2022"; C:C="")))
player00
Related