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.
View best response
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:
Hope that helps