Your sumproduct nearly works, just replace the , with *

=SUMPRODUCT((G9:M16="Pam")*F9:F16)

Note that if Pam appears twice in any row the value in column F for
that row will be counted twice....


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=537755