Hi,
I'm trying to prepare a dashboard using countifs to know how many cells would meet the criteria I have mentioned. Please, go through the excel file to find the formulas I have used. It is self-explainatory. The drop-down table has induvidual drop-downs against the Role, Shift & Status (in F7, G7 & H7); whose values would be used as criteria for my countif function. As you can see, induvidually taken, these countif functions with multiple criteria works fine and returns results in F8, G8 & H8.
Normally, One would use countifs function to club multiple countif functions. But in my case, it would not return the correct value. Kindly help me to understand what can I do to return the correct value in cell F14.
P.S. I have tried using pivots and slicers to get the result. But I need this exact method to implement it in further reports. Thanks in Advance.