excel training onsite - totals

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training onsite - Totals

excel training onsite - Totals

resolvedResolved · Low Priority · Version Standard

Carol has attended:
Excel Introduction course

Totals

how do I get my total column to total each individual row?

RE: Totals

Hi Carol,

Thanks for the question.

You can use the sum function =sum( then drag you cursor over the selection you want to add up and press enter.

Hope this helps, if there is anyhting else let me know

Tracy


 

Excel tip:

Convert Text into Number

Some times numbers maybe imported in as text or you maybe concatenating numbers that form a text string that now are treated, because you had to extract them by Text functions

To convert Text into Number just encase the relevant cell reference or formula in the TEXT function. See Converting American Date to European hint

eg TEXT(Ref) or TEXT(formula)

View all Excel hints and tips


Server loaded in 0.09 secs.