Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
extending a horizontally calculated formula vertically
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I arrange tabs vertically in Excel (not horizontally)? | Excel Discussion (Misc queries) | |||
How do I freeze panes horizontally and vertically at same time | Excel Discussion (Misc queries) | |||
aligning sheet tabs vertically, not horizontally | Excel Worksheet Functions | |||
How to create a floating bar chart vertically not horizontally... | Charts and Charting in Excel | |||
Move cells vertically to horizontally | Excel Discussion (Misc queries) |