how to use countifs where I should include 2 col and ignore few value of 3rd col

[manish.agrawal446@gmail.com]

Hi,


suppose Coulmn A contains "tester name" , Column B contains "status" and Column C contains ETC date


Now I want count of total issues in a particular tester and particluar status but not to include a particular ETC

 

[Faseeh]

Hi Manish,


Suppose You data look like this in A1:C4...

[pre]

Col A	Col B	Col C
A	B	C
A	B	C
A	B	D

Your criteria range like this in E1:G2...


[code]Match A	Match B	Else C
A	B	D[/pre]
....this will work: 


=COUNTIFS(A2:A4,E2,B2:B4,F2,C2:C4,"<>"&G2)

Or


=SUMPRODUCT((A2:A4=E2)*(B2:B4=F2)*(C2:C4<>G2))[/code]


Regards,

Faseeh

 

[manish.agrawal446@gmail.com]

Thanks... Its working fine.....