Making Workshet Flexible

[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/D215,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?

 

[Frank Kabel]

Hi
see answer for your other post (2/5/2004 22:28)

Frank