Help with Formula

  • Thread starter Thread starter Charles McNabb
  • Start date Start date
C

Charles McNabb

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

For example: Using the array =ROUND(C2:C15/D2:D15,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.
 
Hi Charles
one way: replace your array formula with
=IF(D2:D15=0,"",ROUND(C2:C15/D2:D15,2))
Then the average should work.

Frank
 
Back
Top