Using 'AND' logic in a SUMIF statement

I

IpcTrain

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.
 
B

Bernie Deitrick

=SUMPRODUCT((Salary!G9:G62=62008)*(Salary!J9:J62=40102)*(Salary!Y9:Y62))

HTH,
Bernie
MS Excel MVP
 
B

Bob Phillips

=SUMPRODUCT(--(Salary!G9:G62=62008),--(Salary!J9:J62=40102),Salary!Y9:Y62)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

problem with excel logic, too complicated of a function set??? 3
SumIf AND 6
Can I have two conditions in a SUMIF? 5
SUMIF Multiple Criteria in different ranges. 13
Mulitiple Criteria using SUMIF 3
sumif function leaving a blank cell when criteria not met 3
using SUMIF function with compound conditions 12
Can SUMIF function include AND function 1

Top