Hi, can anyone help me?
I would like to count number of occurrences in column Z if two possible values occur as referenced from "Drop down lists" worksheet, in addition to the other columns as noted in the formula. For column Z, if I use a single criteria for example Z9:Z1000,'Drop down lists'!$J$21 or 'Drop down lists'!$J$22 , it counts fine. But when I use both it does not count either. I've tried using nested AND and OR functions to include both 'Drop down lists'!$J$21,Z9 & 'Drop down lists'!$J$22 criteria and still nothing.
=COUNTIFS(E9:E1000,$F$1,Z9:Z1000,'Drop down lists'!$J$21,Z9:Z1000,'Drop down lists'!$J$22,Y9:Y1000,">="&DB1,Y9:Y1000,"<="&DB2)
Please help.
Bookmarks