Forum Discussion

vigneshasokan7's avatar
vigneshasokan7
Copper Contributor
Feb 13, 2019
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 advise the formula.

 

Thanks in advance. 

excel
  • Haytham Amairah's avatar
    Haytham Amairah
    Feb 14, 2019

    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

2 Replies

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Feb 14, 2019

    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