Help with Formula

[Charles McNabb]

How can I make the Worksheet work to different amounts
of data?

For example: Using the array =ROUND(C2:C15/D215,2) for
Column E and =ROUND(AVERAGE(E2:E15),2) for cell E19.

When I have 15 entries everything works fine, but say I
only have 5 entries. Column E ends up with cells E6-E15
having #Div/0!. Cell E19 does not give an average.

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.

 

[Frank Kabel]

Hi Charles
one way: replace your array formula with
=IF(D215=0,"",ROUND(C2:C15/D215,2))
Then the average should work.

Frank