How to count only under certain conditions

Copper Contributor

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/20Complete
1/4/21Complete

I've tried using if, count, and countif normally and as matrices but am having no luck. 

Thank you in advance!!

1 Reply

@smjoyce 

That could be as

image.png

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