Can I use multiple criteria in SUMIF funqtion?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can I use multiple criteria in SUMIF funqtion?
For example, I want date and quantity sold to be criterias that filter out
the data and I do not want to use DSUM funqtion. I am using Excel 2003.
 
Do you just want a sum?

=SUMPRODUCT(--(A2:A100="value1"),--(B2:B100=17),C2:C100)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

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

SUMIFS, one criteria range, multiple criteria 3
Multiple SUMIF criteria 1
sumif wildcard criteria 1
Sumif with Multiple Criteria 3
SUMIF with criteria "<>" & "=" 4
Sumif using Arrays 2
Sumifs - greater than criteria with a Cell Reference 3
SUMIFS 5

Back
Top