Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
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?
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.
