extending a horizontally calculated formula vertically
That doesn't look like a valid formula to me.
You may want to select the cell and copy the formula from the formulabar. And
then pasted into your response.
FoulDwimmerlaik wrote:
that didn't seem to work; it just kept repeating the total for that specific
line. If it helps any, my actual formula is this :
=SUM(K)+(C*3)+(F*3)+(E*5)+(I*5)
"FSt1" wrote:
hi
the formula should read something like this..
in E2...=sum(A1+B1+C1+(D1*2))
copy the formula and paste it as far down as you need. xl will adjust the
row numbers for you.
Regards
FSt1
"FoulDwimmerlaik" wrote:
I have a list of several hundred items with numeric values extending
horizontally from them. I have created a formula to tabulate these values to
create a total to the right of the last cell for each item. However, I do
not wish to retype the formula for each row, how do I apply the formula to
the entire list so each row will have its own total? example:
A B C D E
Entry1 10 10 10 10 50
formula is A+B+C+(D*2)=E
How do I apply this formula to each row without having to enter it and
change the row number withing the formula for every single row?? Thanks!
--
Dave Peterson
|