View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Looping through Looping through is offline
external usenet poster
 
Posts: 69
Default 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