Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUM Function
I am trying to add values in a column filtered by multiple criteria. For ex,
I want to SUM all items described in column H as "Part A" but only if column J lists the part as "NEW". I have tried various formulas but I continue to get error messages. Any suggestions would be appreciated. Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUM Function
Nel ,
readystate ha scritto: I am trying to add values in a column filtered by multiple criteria. For ex, I want to SUM all items described in column H as "Part A" but only if column J lists the part as "NEW". I have tried various formulas but I continue to get error messages. Any suggestions would be appreciated. Thanks. Hi, you can use the SUMPRODUCT function. For example, if your data are from row 2 to row 100, the formula could be: =SUMPRODUCT(($H$2:$H$100="Part A")*($J$2:$J$100="NEW") -- (I'm not sure of names of menus, options and commands, because translating from the Italian version of Excel...) Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUM Function
The formula Franz provided will count the number of rows meeting the dual
criteria. If you need to add associated values from another column, say column K, it would be =SUMPRODUCT(--($H$2:$H$100="Part A"),--($J$2:$J$100="NEW"),($K$2:$K$100)) "Franz Verga" wrote: Nel , readystate ha scritto: I am trying to add values in a column filtered by multiple criteria. For ex, I want to SUM all items described in column H as "Part A" but only if column J lists the part as "NEW". I have tried various formulas but I continue to get error messages. Any suggestions would be appreciated. Thanks. Hi, you can use the SUMPRODUCT function. For example, if your data are from row 2 to row 100, the formula could be: =SUMPRODUCT(($H$2:$H$100="Part A")*($J$2:$J$100="NEW") -- (I'm not sure of names of menus, options and commands, because translating from the Italian version of Excel...) Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUM Function
This worked great...thanks so much and have a great day!!!
"bpeltzer" wrote: The formula Franz provided will count the number of rows meeting the dual criteria. If you need to add associated values from another column, say column K, it would be =SUMPRODUCT(--($H$2:$H$100="Part A"),--($J$2:$J$100="NEW"),($K$2:$K$100)) "Franz Verga" wrote: Nel , readystate ha scritto: I am trying to add values in a column filtered by multiple criteria. For ex, I want to SUM all items described in column H as "Part A" but only if column J lists the part as "NEW". I have tried various formulas but I continue to get error messages. Any suggestions would be appreciated. Thanks. Hi, you can use the SUMPRODUCT function. For example, if your data are from row 2 to row 100, the formula could be: =SUMPRODUCT(($H$2:$H$100="Part A")*($J$2:$J$100="NEW") -- (I'm not sure of names of menus, options and commands, because translating from the Italian version of Excel...) Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions |