Hi Candygirl,

Welcome to the board,

You are applying multiple criteria in single column.. so It is better to use sumproduct:

Use below formula: for Column C I have given my own criteria...Please change accordingly.


Code:
=SUMPRODUCT(--ISNUMBER(MATCH(B1:B5,{"Land";"Build";"Demolish"},0)),--(A1:A5="nsw"),--ISNUMBER(MATCH(C1:C5,{"abc";"def";"xxx"},0)),K1:K5)