Countifs with 3 criteria

[Aland2929]

I need to count based on 3 criteria but my formula is not working. I have attached a sample file.
Thanks in advance

[vlady]

try

array formula

=SUM(COUNTIFS(A:A,$D$2:$E$2,B:B,G2))

[Winon]

Hello Aland2929,

The attached WorkBook shows how I would do it. You could easily expand on the layout to include counts of more Locations.

[Aland2929]

Thanks for the prompt response. I will use the array formula.