Formula SUMIFS
Hello
I need to assemble a SUMIFS formula with the entire column.
when I put a line limit the formula accepts and I have the result but when I put it for all the lines typed the formula comes out invalid.
What do I need to do to use this formula as an example or do we have another formula that will give the same result?
my goal is to add up the idle hours for each reason but separated by month.
Answers

I can see that you're referencing columns that also contain formulas. If there's even 1 cell with an error in any of those columns, it will give you an error in your new formula as well.
You can wrap an IFERROR statement around whatever column formula you have, like so:
=IFERROR(formula, "")
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8  10, Seattle, WA  Register now 
Thanks nice idea. great successful about the problem
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.3K Get Help
 321 Global Discussions
 197 Industry Talk
 418 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 278 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!