Formula SUMIFS

Adilson Mota

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?

Formula SUMIFS.PNG

my goal is to add up the idle hours for each reason but separated by month.

Genevieve P.

Hi @Adilson Mota

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

Adilson Mota

Thanks nice idea. great successful about the problem