SUM Function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Nel post:[email protected],
readystate said:
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.
Click to expand...

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
 
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))
 
Back
Top