Forum Discussion
Solved
Count if using multiple criteria rows and columns
Hi! I have a doubt, I need to get the count of Present "P" from the criteria for India Operation in Dubai and Specific date. Ex: On 14 Feb no. Of presents in India Operation (Dubai). Please ...
Hi,
The 14 Feb column is empty!
But I fill it with the 5 Feb's data to test the solution.
So, please see this formula in the attached file:
=COUNTIFS($A$3:$A$150,$AF$4,$B$3:$B$150,AF5,INDEX($C$3:$AD$150,,MATCH($AI$2,$C$2:$AD$2,0)),"P")
Hope that helps
Hi,
The 14 Feb column is empty!
But I fill it with the 5 Feb's data to test the solution.
So, please see this formula in the attached file:
=COUNTIFS($A$3:$A$150,$AF$4,$B$3:$B$150,AF5,INDEX($C$3:$AD$150,,MATCH($AI$2,$C$2:$AD$2,0)),"P")
Hope that helps
thanks a ton..