SUM with Multiple Criteria

[Haseeb A]

Or use SUMIFS like,

=SUM(SUMIFS(D:D,A:A,"nsw",B:B,{"build";"land";"demolish"},C:C,{"a","b","c"}))

Note: If first array separated by colon, then 2nd one should be be comma, If first array is separated by comma then 2nd should be colon.

Or as Admin suggested use SUMIFS like, ARRAY entered.

=SUM(SUMIFS(D:D,A:A,F2,B:B,G2:G4,C:C,TRANSPOSE(H2:H4)))

[candygirl]

Thanks Haseeb,
I went with the first code and it worked perfectly!.
Thanks very much.