Can you reference multiple columns when using SUMIF?


I need to add values in 6 or 7 different entire columns when a certain condition is met.

When I reference only one column the formula works, but when I expand to two or more, I get an Incorrect Argument error. Is this not possible?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!