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