Hi,
Try
=SUMPRODUCT(--(A2:A289=F2),--ISNUMBER(MATCH(B2:B289,G2:G4,0)),--ISNUMBER(MATCH(C2:C289,H2:H4,0)),D2: D289)
where
F2 = NSW
G2:G4 = Build,Land,demolish
H2:H4 = A,B,C
HTH
Hi,
Try
=SUMPRODUCT(--(A2:A289=F2),--ISNUMBER(MATCH(B2:B289,G2:G4,0)),--ISNUMBER(MATCH(C2:C289,H2:H4,0)),D2: D289)
where
F2 = NSW
G2:G4 = Build,Land,demolish
H2:H4 = A,B,C
HTH
Cheers !
Excel Range to BBCode Table
Use Social Networking Tools If You Like the Answers !
Message to Cross Posters
@ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)
Posting Permissions
Reply With Quote
Bookmarks