Feb 13 2019 11:21 PM
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 advise the formula.
Thanks in advance.
Feb 14 2019 08:58 AM
SolutionHi,
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
Feb 14 2019 08:58 AM
SolutionHi,
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