SOLVED

Count if using multiple criteria rows and columns

Copper Contributor

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. 

2 Replies
best response confirmed by vigneshasokan7 (Copper Contributor)
Solution

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")

COUNTIFS.png 

 

Hope that helps

thanks a ton..
1 best response

Accepted Solutions
best response confirmed by vigneshasokan7 (Copper Contributor)
Solution

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")

COUNTIFS.png 

 

Hope that helps

View solution in original post