I have a formula:
to compute a percentage of
I inputs divided by
<> (all other inputs) and I need to omit blank cells. The
IFERROR formula just keeps the cell blank until data is entered in the corresponding row.
I want this formula to extend to every new row of a column. I have used
ARRAYFORMULA before to automatically extend the formula to new rows but I can't figure out how to use it (or something else?) in this case.