I am using =COUNTIFS(Assignments!$G$2:$G$2633,A7,Assignments!$K$2:$K$2633,"<="&M7,Assignments!$O$2:$O$2633,">"&L7)
I want the last criteria to include records where column O is blank.
Excel Workbook | |||
---|---|---|---|
G | |||
5 | 2632 | ||
Course Dates |
I am using =COUNTIFS(Assignments!$G$2:$G$2633,A7,Assignments!$K$2:$K$2633,"<="&M7,Assignments!$O$2:$O$2633,">"&L7)+Countblanks(Assignments!$O$2:$O$2633)
I want the last criteria to include records where column O is blank.