Looking up dates against statuses

**leelnich** · 02-01-2018, 06:02 PM

Just add another criteria_range and criteria. If the project is specified in cell I4:

=COUNTIFS($C$2:$C$16,"Interview",$E$2:$E$16,">="&$H$4,$E$2:$E$16,"<"&$H$4+7,$B$2:$B$16,$I$4)

Note that inserting a column caused the references to change. This is automatic, and by design.

**RED12345** · 02-01-2018, 06:18 PM

Great, thanks

One more question - how could I show the project with the most interviews within a given week AND across the whole sheet?

Re: Looking up dates against statuses