Sum column based on text of another
 

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

Sum column based on text of another
 

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

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