My spreadsheet it like this

10ft 12ft 14ft 14ft ect.......

what i would like to do is anytime a 10ft is used i would add the number
used ie:

10ft 12ft
3 6
4 2
Total Total

etc.................

so every column will change as something is added

Thank you for helping

"FloMM2" wrote:

Dottled,
If I understand you correctly, try this:
Column A has dates in it, Column B thru whatever has numbers.
Below, in every column you would like a total,as of the new date that is
entered.

In a new worksheet, put a few rows of data in across your worksheet.

Skip a row, in the next row.
Cell A - Type "Totals"
Cell B - In Cell B5 Type "=SUM(B1:B4)", this is if Cell B4 is empty.
Cell C - Copy Cell B5, across the worksheet to the last column of data.

The next time you eneter data, select the blank row, and "Insert" a row.
Your formula will automatically change.
hth
Dennis

"Dottled" wrote:

I would like a forumula so that i can total several columns in a spreadsheet
indefinitely. The rows of data which will change every day and i would like
to be able to add new data to every row and for it to total up every column
indefinitely