SUMIF with two Ranges.??

I want to create a cross-sheet formula and have two conditions for the formula to go through to result in a value. 

If the value in column1 is 1 and column2 is VendorX then sum all values in column3 corresponding to the conditions. 

I am not sure if the SUMIF will work for this. 



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!