| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting a mixed text/number column based on text in another colum | Excel Discussion (Misc queries) | |||
| Text to column and selecting values based on a different column | Excel Worksheet Functions | |||
| Text to column and selecting values based on a different column | Excel Worksheet Functions | |||
| Text to column and selecting values based on a different column | Excel Discussion (Misc queries) | |||
| Putting text in a column based on variable text from another colum | Excel Discussion (Misc queries) | |||
Linear Mode
