Try this:

=SUMPRODUCT(--(Sheet2!A$2:A$5=A2),--(Sheet2!B$2:B$5=B2),Sheet2!C$2:C$5)

--
Biff
Microsoft Excel MVP


"jmegdan1" wrote in message
...
2 worksheets

Sheet 1
Area Sector Year
Berkley Retail (BLANK)
Berkley Office (BLANK)
Clawson Retail (BLANK)
Clawson Office (BLANK)


Sheet 2
Area Sector Year
Berkley Retail 1
Clawson Retail 4
Clawson Office 3
Berkley Office 2


How do I get the Year value in sheet 2 to populate into sheet 1 based on 2
matched criteria?