software

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 quot;62008quot; AND J9:J62 on
the Salary worksheet for value quot;40102quot; then summing Y9:Y62 of the
Salary worksheet, matching these conditions. The return value is
entered on another worksheet of the same workbook. Thanks.=SUMPRODUCT((Salary!G9:G62=62008)*(Salary!J9:J62=4 0102)*(Salary!Y9:Y62))

HTH,
Bernie
MS Excel MVPquot;IpcTrainquot; gt; wrote in message ups.com...
gt; In EXCEL 2003, how can I incorporate 'AND' logic in a 'SUMIF'
gt; statement? If not, what other function can I use to sum a column of
gt; cells given TWO conditions. This is what I have and it does not work:
gt; =SUMIF(Salary!G9:G62,62008 AND(Salary!J9:J62,40102 ),Salary!Y9:Y62). I'm
gt; testing G9:G62 on the Salary worksheet for value quot;62008quot; AND J9:J62 on
gt; the Salary worksheet for value quot;40102quot; then summing Y9:Y62 of the
gt; Salary worksheet, matching these conditions. The return value is
gt; entered on another worksheet of the same workbook. Thanks.
gt;
=SUMPRODUCT(--(Salary!G9:G62=62008),--(Salary!J9:J62=40102),Salary!Y9:Y62)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;IpcTrainquot; gt; wrote in message ups.com...
gt; In EXCEL 2003, how can I incorporate 'AND' logic in a 'SUMIF'
gt; statement? If not, what other function can I use to sum a column of
gt; cells given TWO conditions. This is what I have and it does not work:
gt; =SUMIF(Salary!G9:G62,62008 AND(Salary!J9:J62,40102 ),Salary!Y9:Y62). I'm
gt; testing G9:G62 on the Salary worksheet for value quot;62008quot; AND J9:J62 on
gt; the Salary worksheet for value quot;40102quot; then summing Y9:Y62 of the
gt; Salary worksheet, matching these conditions. The return value is
gt; entered on another worksheet of the same workbook. Thanks.
gt;