excel training microsoft - formulas

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 microsoft - Formulas

excel training microsoft - Formulas

resolvedResolved · Low Priority · Version Standard

Kim has attended:
Excel Intermediate course

Formulas

How do you create a formula in order to add two columns together to obtain a grand total?

RE: Formulas

=SUM(A:A)+SUM(B:B)

RE: Formulas

Yes, that is correct.


 

Excel tip:

Separate the year from a date

To separate the year from a date use the =year() function, eg a date is in cell A1 and in A2 you wish to display the year enter the function =year(A1)

View all Excel hints and tips


Server loaded in 0.08 secs.