Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating over Multiple Columns
I have a spreadsheet as follows
A B C 1 10 78 46 2 27 46 32 3 45 99 86 Is it possible to highlight all the cells and then divide by 3.3. Currently I put a formula in D,E,F and then drag down. Can I avoid this last step and just highlight A,B.C and do some magic? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating averages in sorted columns | Excel Discussion (Misc queries) | |||
Calculating Differences between columns in a Pivot Table | Excel Discussion (Misc queries) | |||
Calculating values in two columns based on a variable | Excel Discussion (Misc queries) | |||
calculating adjacent columns in a work schedule | Excel Worksheet Functions | |||
calculating adjacent columns in a work schedule | Excel Worksheet Functions |