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

Thanks nice idea. great successful about the problem
Help Article Resources
Categories
Check out the Formula Handbook template!