SUMIFS Function with Multiple Column Sum Range

Jim Hook

I want to sum values over a two column range using multiple criteria but when I include more than one column in the sum range I get a #MISSING OR INVALID PARAMETERS error message. When I back off the sum range to a single column it works fine. Is the sum range in the SUMIFS function restricted to a single column?

Jim Hook

I just heard back from Smartsheet support that the SUMIFS function only sums within a single column. There is a way to do it by putting two SUMIFSs in a single formula, one that sums the desired range in each column. I ended up finding a better way to organize the data and a single SUMIFS works great.

 

 

Travis

Thanks for following up! 

Wanda T

Thank you for posting this discussion Jim, I was trying to do something similar today and this information was helpful.