SUM with Multiple Criteria

[littleiitin]

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.

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

[candygirl]

Hi littleiitin,
Thanks so much for your reply.
I tried your formula and received a 0 value.
I have attached an example.
I would like to add D, if A = NSW, B = Build, Land or Demolish and C = A, B or C.
Hope this makes sense.
Thanks again.