excel, how do I get sumif with two criterias?

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

Guest

I've got a table with many columns and I want to add the last left column but
using two criterias for two different columns.
 
=SUMPRODUCT(--(rng1="criteria1"),--(rng2="criteria2"),rng3)

the ranges cannot be whole columns

--

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

SUMIF with criteria "<>" & "=" 4
SUMIFS, one criteria range, multiple criteria 3
Really need some help with a multi conditional SumProduct 1
SUMIF Function 3
Multiple SUMIF criteria 1
SUMIFS with an OR criteria 8
Sum on multiple columns with search criteria 6
Sumif Question 1

Back
Top