General discussion
March 9, 2006 at 09:47 PM
ipctrain

Using ‘AND’ Logic in a ‘SUMIF’ Statement

by ipctrain . Updated 20 years, 7 months ago

In EXCEL 2003, how can I incorporate ‘AND’ logic in a ‘SUMIF’ statement? If not, what other function can I use to sum a column of cells given TWO conditions. This is what I have and it does not work: =SUMIF(Salary!G9:G62,62008+AND(Salary!J9:J62,40102),Salary!Y9:Y62). I’m testing G9:G62 for value “62008” AND J9:J62 for value “40102” then sum Y9:Y62, matching these conditions. The return value is entered on another worksheet. Thanks.

This discussion is locked

All Comments