Help!
I have a spreadsheet with resolved (Status Col D) and a date (Status Col E). On another sheet I want to count the different resolved types only if they are type A and B and roll the dates in Status Column E up to the months in Assess Col A
I have tried the following;
When I enter COUNTIFS(Status!$D$4:$D$34,"A",Status!D4:D34,"B",Status!$E$4:$E$34,">="&Assess!A6,Status!$E$4:$E$34,"<="&EOMONTH(Assess!A6,0)) it returns 0 but it should result in 2
COUNTIFS(Status!$D$4:$D$34,"A",Status!$E$4:$E$34,">="&Assess!A7,Status!$E$4:$E$34,"<="&EOMONTH(Assess!A7,0)) it returns the correct value of 1
What is the best formula to enter to count when resolved = A and B and roll up all instances of A and B into the relevant month
Thanks
Bookmarks