Blank cells, iferror?
Hello! i think i need an iferror to ignore the blank cells but i havent fully wrapped my head around those yet :)
three things in this
 90+ Total current formula is =SUM([90+]@row:[180+]@row) but i want to ignore the blank lines
 same for % over 90 current formula is =([90+ Total]@row / Total@row)
 adding the % over 90 as a formula screwed up my "Previous Month" which compared to a prior month and added directional arrows depending if they increase or decrease. current formula is =IFERROR(IF(Month@row <> "", IF(INDEX([% over 90]:[% over 90], MAX(COLLECT(Row:Row, Row:Row, @cell < Row@row, Insurance:Insurance, @cell = Insurance@row))) < [% over 90]@row, "Up", IF(INDEX([% over 90]:[% over 90], MAX(COLLECT(Row:Row, Row:Row, @cell < Row@row, Insurance:Insurance, @cell = Insurance@row))) > [% over 90]@row, "Down"))), "")
Answers

You need to use an IFERROR to get rid of the divide by zero errors.

Thanks @Paul Newcome
I got the % over 90 to work with if error but im not 100% sure on this one
=SUM([90+]@row:[180+]@row)
i tried this =IFERROR([90+]@row:[180+]@row, "") but it didnt work

What do you mean by "it didn't work"? Is it throwing an error? Is it outputting something different? Is it breaking something else?

@Paul Newcome yes when i use that formula i am getting an Invalid Column Value error

Oh. Because you aren't keeping the SUM function in there.

okay so add the SUM, im still having a bit of trouble on where to place it ive tried the below, neither worked
=IFERROR(SUM[90+]@row:[180+]@row, "")
=SUM([90+]@row:[180+]@row, IFERROR(90+ Total(@cell), ""))
trying to go through old threads and find my answer but im just not getting it correct.

In the first one, you need to close out the SUM function before moving on to the second part of the IFERROR.
=IFERROR(SUM(.....), "")


How exactly are those columns being populated?
Help Article Resources
Categories
Check out the Formula Handbook template!