Add or Deduct from cell values in one row?

[tazmtiger]

Hi!

I have a worksheet that contains values that I currently update manually using a hand calculator.

What I am trying to do Is:

Currently; cells "C3:AT3" have accumulative totals, that come from number times repairs are done to a piece of equipment.

I have a "set" total in each cell, cells "C3:AT3", which I have change manually daily to reflect the new totals each day. This totals come from different sources. Mostly other software. Non Excel data.

I need to take each number, for each cell lets say 20 and added to the corresponding cell count which is lets say: 1751. Which lets say it gives me a new total of 1771 for that cell. and a similar process is follow in the other cells in mentioned range. Just with different amounts to each corresponding cell.
My question to you. Is: Can I generate a cell in row 2 to update the totals in the corresponding cells below "in row 3 range C3:AT3?

In other words: Update any Cell in range "C3:AT3" from its corresponding cells in "C2:AT2". and have each cell in range "C2:AT2" reset to zero each time anything is typed to them??

I hope this makes sense?

Hope someone can help??

Thank You!