how do I sum a row in numbers 09?

I am a teacher wanting to sum grades by row, not column.


I've tried dragging the black plus sign down as videos indicate.

No luck...


It is very time intensive to do this by hand when I know there has to be a simply way.


please and thank you--

MacBook Air, OS X Mavericks (10.9.1)

Posted on May 3, 2014 3:46 AM

Reply
2 replies

May 3, 2014 5:30 AM in response to ieduca8

If you want to sum a row, select the cell where you want the answer, then type the equal sign ("="), then the function you want (in your case "sum(", include the open paerenthesis, click the row header (the number on the very left):


User uploaded file

they type the close parenthesis:

User uploaded file


In this example :

A7=SUM(5:5)


this is shorthand for.... select cell A7, then type (or copy and paste from here) the formula:

=SUM(5:5)



you can also use the "quick" method which is:

1) select the row

2) drag the sum tag from the quick caluclations from the bar at the bottom to th ecell where you want it:

User uploaded file


User uploaded file

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

how do I sum a row in numbers 09?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.