Jasmine,

Using your sample data in A1:C5,

=SUMPRODUCT((A1:A5="Region 1")*(OFFSET(C1:C5,1,0)))

This returned 75000 for Region 1 and 145000 for Region 2.

Does that help?

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=539921