Trudat wrote:
It is probably because the values are not exactly 6.87 and 6.65, but you
have the display at 2 dec places. Increase the dec places and re-do the
[quoted text clipped - 5 lines]

Help me understand what I am doing wrong. Thank you in advance for any help.

I did change it out to 8 and same totals. The strange part is I can make
this work when I put the values in with out the averages from the other lines.

You were right . I had went out to 8 digits on each line but not the total
field. Once the total field was out to 8 digits the spread sheet was right.
The average was correct at 3.19% not 3.20% Thank you for the help.

--
Message posted via http://www.officekb.com