Hi
I am using the below formula to get a summarized view in the picture below
=IF(AND(C7="All",B7="All",D7="All"),COUNTA('July Hr report'!D:D,Summary!B7),COUNTIFS('July Hr report'!B:B,Summary!B7,'July Hr report'!L:L,Summary!C7,'July Hr report'!M:M,Summary!D7))
Capture.PNG
the problem is when i select "All" from the drop down list(Coloumn Location City, SSL,SMU) this formula doesn't gives me the appropriate count
I have "All" as dropdown for coloumns "Location City","SSL","SMU"
Capture1.PNG
what is incorrect in my formula, can you please help?
Bookmarks