SUMIF with two Ranges.??

Swathi.Chaturvedi

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. 

 

Brian W

You should be able to use SUMIFS which checks multiple ranges, like this:

=SUMIFS([Column 3]:[Column 3], [Column 1]:[Column 1], @cell = 1, [Column 2]:[Column 2], @cell = "VendorX")

Swathi.Chaturvedi

I'll try this and let you know if it works! Thanks!

Swathi.Chaturvedi

It worked!!! Thank you!