Jan 15 2021 09:05 AM
Hi!
So I have a table with multiple columns. For a given range of dates, I would like to count how many times the word "Complete" appears in the next column.
Example, if I were looking between the dates 12/16/20 and 1/1/21, I would expect the answer to be 1 from the following table.
Date | Finished |
12/20/20 | Incomplete |
12/21/20 | Complete |
1/4/21 | Complete |
I've tried using if, count, and countif normally and as matrices but am having no luck.
Thank you in advance!!
Jan 15 2021 09:19 AM
That could be as
with
=COUNTIFS(D5:D7, ">="&DATE(2020,12,16),D5:D7, "<="&DATE(2021,1,1),E5:E7,"Complete")
but better not to hardcode parameters within formula