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 on the Salary worksheet for value "62008" AND J9:J62 on
the Salary worksheet for value "40102" then summing Y9:Y62 of the
Salary worksheet, matching these conditions. The return value is
entered on another worksheet of the same workbook. Thanks.