=SUMPRODUCT(--($A$2:$A$200="criteria1"),--($B$2:$B$200="criteria2"),--($E$2:
$E$200="criteria3"),$F$2:$F$00)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Teri" wrote in message
...
I must match criteria in Columns A, B, and E, to get a total revenue from
Column F. I'm going nuts trying to do this. Any ideas?