L
Looping through
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
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