Count with Multiple Criteria

[candygirl]

Hi Again Excel Championsm

I'm stuck on another excel formula.
I need to count if:
column A equals "NSW"
Column B equals "Demolish", "Land", or "Build"
Column C equals "A" or "B"
Column D equals "Industrial.

I have attached an example.

Thanks in advance.

[Admin]

Hi,

Try

=SUM(COUNTIFS(A:A,"NSW",B:B,{"demolish","land","build"},C:C,{"a";"b"},D: D,"industrial"))

[candygirl]

Thanks Admin,
Worked perfect!:D

[Admin]

You are welcome !! :cheers: