Excel '07
ColumnA | ColumnB | ColumnC | ColumnD| ColumnE | ColumnF | ColumnG |
data | 123 | data | 456 | data | 789 | =SUM(B2,D2,F2)
How can I sum columns B, D & F in column G without the need to copy the formula each time a new row is added?
Users enter about 10 new rows of data each day and I would prefer that I don't have to copy the formula to a few thousand rows every once and awhile, nor expect the users to correctly copy the formula.
I believe I did this once using an ARRAY but I don't remember how I did it.
Thanks in advance!
Bookmarks