Just SUM which will not round. If your numbers are exactly 6 decimals, then
display answer with 6 decimals.

You could format your cells with 7 decimals (last digit should be 0?) and
check SUM this way.

"Janet" wrote:

I am using SUM to add up a column with numbers that have six decimals. I do
not want the answer to be rounded up. How can I create a formula not to round
the answer, using SUM? Thanks