SUMIF with two Ranges.??

12/05/18 Edited 12/09/19

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. 

 

Comments

Sign In or Register to comment.