I'm trying to count the total number of various statuses that occur between two dates.
Please see attached.
I've tried the formula =COUNTIFS($C$2:$G$11,">="&K$1,$C$2:$G$11,"<"&L$1,$B$2:$B$11,K2)
But this only seems to work for one column of dates or when you exclude the last criteria.
Any help appreciated.
Bookmarks