On Excel, how do I change from "average" to "sum" when I highlight a column of numbers?

Answer 1

If you are talking about the value that appears at the bottom of the window frame in Excel when you have a column highlighted, then simple right click where it says average, and then change it to sum from the menu that appears.

Answer 2

I'm not entirely sure I've got your question right, but if you do a 'search and replace' (under Edit) once the column is highlighted you can swap the word average for the word sum in each cells formula

Answer 3

Mouseover the Autosum button (Greek letter sigma) on your toolbar. A down arrow will appear. Click the down arrow and select "average." You column of numbers will then be averaged rather than summed. If you don't see the Autosum button, click View | Toolbars and make sure the Standard toolbar is checked.

Answer 4

Left click on the drop down arrow next to the sum icon in the task bar - you get the selection (average, sum, count, max, min) - just click on sum and it will change.

Answer 5

Highlight your column, then right click over "average" and select "sum" from the ticklist.

Answer 6

On the "Standard" toolbar......click on the drop down arrow (to the right of the big backwards looking E) and click "Average".

Answer 7

Right-Click the result on the Status Bar and choose the function you need.

Answer 8

Click on the sign that looks like an 'M' on its side on the tool bar across the top.

Answer 9

If all else fails try "help" - quicker and easier to follow than answers

Answer 10

when you are putting in the formula, put in =sum instead of =ave. i.e. =sum (a1:a15) rather than =ave(a1:a15). This should work.