My Formulas are 1st row =($B$4+C4) and 2nd row is =($B$5+C5) and so on.

"Otto Moehrbach" wrote:

Sherry
Apparently the formulas you have in the second column are giving you the
result you are getting. Post back and tell us what you want to happen and
include the formulas you now have in the second column. Include just a
couple of the formulas. HTH Otto
"Sherry" wrote in message
...
I have this page setup with formulas for each row to keep totals but when I
add a number to nest row it adds that number and the number from the
previous
row how do I get around this? I will mention I am new at this and it has
been
learn as I go.
Amount Sold Total
Jam 1 1
Spread 2 3?Why