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.

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

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

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