sumif (with two criterias)

W

Werner

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
 
R

Rojee

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
 
Top