sumif (with two criterias)

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

Guest

I use following Syntax which works very well:
sumif(c4:u620;e777;w4:w621)
the cell "e77 " is the criteria

how can I summarize when I use two criterias?
For example the criterias are on cell E777 and F777
 
You can concatenate the values of E777 and F777
e.g =(E777&F777) or =concatenate(E777:F777)
Result is E777F777
and you will have the result of E777F777...
With this result you can use the sunif function
 
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 CRITERIA PROBLEM 8
Criteria Syntax in SUMIF formula 10
SUMIF using 2 cells that equal each other 1
Access Dcount (multiple criteria) 3
sumif with 2 criteria? 10
SUMIFS error 1
SUMIF - how to enter a second criteria 1
SUMIF 2

Back
Top