The attached workbook employs simple COUNTIFS formulas. For Interviews:Other Status categories would take similar form.![]()
=COUNTIFS($B$2:$B$16,"Interview",$D$2:$D$16,">="&$G$4,$D$2:$D$16,"<"&$G$4+7)
The attached workbook employs simple COUNTIFS formulas. For Interviews:Other Status categories would take similar form.![]()
=COUNTIFS($B$2:$B$16,"Interview",$D$2:$D$16,">="&$G$4,$D$2:$D$16,"<"&$G$4+7)
Clicking the Add Reputation star below helpful posts is a great way to show your appreciation.
Please mark your threads as SOLVED upon conclusion (Thread Tools above Post # 1). - Lee
Thank you so much, could I ask (pic attached) - how would I show how many interviews but against a certaIn project i.e how many interviews did project ABC have W/C 08/01?Excel Example.png
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks