Try this:

=SUMPRODUCT(--('Master Log 2008'!E28:E80="Utility"),--('Master Log
2008'!$L$28:$L$80="Won"),'Master Log 2008'!$J$28:$J$80)

HTH,
Paul

--

"Looping through" wrote in
message ...
I need a formula that will sum column J based on if the word "Utility" is
found with the text in the adjacent cell in column E and if the adjacent
cell
in column P = "Won".

This is what I have started with.

=SUMPRODUCT(--ISNUMBER(MATCH("Utility",'Master Log 2008'!E28:E80)*('Master
Log 2008'!$L$28:$L$80="Won"),('Master Log 2008'!$J$28:$J$80)))

Any help is Apprechiated.
Thanks
Peter W