I want to key numeric values in one row like a1 and total them in

[packer7]

I have a report that the numbers change daily with people who key info in, I
want to track their efficiency, so I want to enter the daily number in the
same row like a1, b1, etc. for every day of the month and I want to tabulate
that in row 2 , a2, b2, etc. because I have so many people I am trying to
use as little column and row space is there a formula that will add a chaging
number in one cell to the very next cell and keep a running total? I have
tried this and I keep getting a message that will not let me.

 

[JLatham]

If I understand you correctly, you want to enter numbers in row 1 and keep a
running total of them in row 2?

Starting in Cell A2, put this formula, just as it's shown:
=SUM($A$1:A$1)
and fill it out to the right, it will automatically change the second
reference to A (right after the colon) as it's filled. So in B2 it will
appear as =SUM($A$1:B$1)
and should give you the running total you want.