Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel courses - help auto sum

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel courses - Help with auto sum

excel courses - Help with auto sum

ResolvedVersion Standard

Chris has attended:
Excel Introduction course
Excel Intermediate course

Help with auto sum

How do I use autosum to calculate individual row totals?

RE: Help with auto sum

Hi Chris

Thank you for the question.

You can use the Autosum by either pressing =sum( and then dragging the range of cells you want to add up and pressing enter. For example, =sum(A1:H5).

However if the cells are non-adjacent you can put a comma between the cell references and it will only add up individual cells. For example, =sum( A1,C2,F4) will only add A1+C2+F4.

I hope that answers your question, anything else let me know

Tracy

Excel tip:

Repeat action

The F4 key will usually repeat your last action. e.g. delete a row, then select another row and press F4 to delete again.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.