| 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 |
| 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) | |||
Threaded Mode
