Sum column based on text of another
Sorry, I missed part of it. Try this instead.
=SUMPRODUCT(--(ISNUMBER(SEARCH("Utility",'Master Log
2008'!E28:E80))),--('Master Log 2008'!$L$28:$L$80="Won"),'Master Log
2008'!$J$28:$J$80)
HTH,
Paul
--
"PCLIVE" wrote in message
...
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
|