Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
SUMIFS Function with Multiple Column Sum Range
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?
Comments
-
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.
-
Thanks for following up!
-
Thank you for posting this discussion Jim, I was trying to do something similar today and this information was helpful.
