I have a Microsoft Excel spreadsheet I am trying to extract data from. I want to make a column that gives the sum of values from only certain columns accross a row. I want to do this for many rows, so am looking for a way to do this without having to manually enter each cell individually into an equation.
For example, I am looking only to add, say, the data from columns D,F,H,J,L,N,P,and R, all from cells from the same row. Is there a way to do this with a generic equation, so I do not have to put D3,F3,H3,J3, etc.? I have too many rows to do by manual equation writing. Surely there is an easier way!?
Thanks so much for your help!
2007-08-29
10:54:20
·
3 answers
·
asked by
Anonymous
in
Software