COUNTIFS Statement

[MattH1]

Hi everyone,

I'm using the following COUNTIFS statement:

=SUM(COUNTIFS('Sheet 1'!$Y:$Y,{"DI","GH","YH","ST"},'Sheet 1'!$O:$O,"C"))

and have zero problems with it. In fact, it gives me exactly what I need.

I'm looking to enhance it as I found out I have another set of criteria. I want to add where Column B in tab 'Sheet 1' = "EL" or "CO". Is there any way I can enhance this formula to do that? It's just an extra set of two criteria in that column but I really need this enhancement.

Thanks in advance

 

[Aladin Akyurek]

Try:

=SUM(COUNTIFS('Sheet 1'!$Y:$Y,{"DI","GH","YH","ST"},'Sheet 1'!$O:$O,"C",'Sheet 1'!$B:$B,{"EL";"CO"}))