C
Charles McNabb
I have a worksheet set up using 15 rows for Data.
Several of these cells are part of an array formula.
For example: Using the array =ROUND(C2:C15/D2
15,2) for
Column E and =ROUND(AVERAGE(E2:E15),2) for cell E19.
Problem: If I do not fill in all 15 rows, the columns
being averaged do not get a value. Since the cells with
#Div/0! are part of an array I can't cancel them. If I
enter 0 as a value of the array, then it skews my average.
How can I make the Template Flexible to accept less
information?
Several of these cells are part of an array formula.
For example: Using the array =ROUND(C2:C15/D2
15,2) forColumn E and =ROUND(AVERAGE(E2:E15),2) for cell E19.
Problem: If I do not fill in all 15 rows, the columns
being averaged do not get a value. Since the cells with
#Div/0! are part of an array I can't cancel them. If I
enter 0 as a value of the array, then it skews my average.
How can I make the Template Flexible to accept less
information?