Blank cells, iferror?

ldavenportHAP

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

1. 90+ Total current formula is =SUM([90+]@row:[180+]@row) but i want to ignore the blank lines
2. same for % over 90 current formula is =([90+ Total]@row / Total@row)
3. 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"))), "")

Paul Newcome

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

ldavenportHAP

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

Paul Newcome

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

ldavenportHAP

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

Paul Newcome

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

ldavenportHAP

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.

Paul Newcome

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

=IFERROR(SUM(.....), "")

ldavenportHAP

@Paul Newcome

thank you! it seemed to accept that formula but i am still showing zeros

Paul Newcome

How exactly are those columns being populated?