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

microsoft+excel+course - to add up cells

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft+excel+course - To add up cells

microsoft+excel+course - To add up cells

ResolvedVersion Standard

Natasha has attended:
Excel Introduction course
Excel Intermediate course

To add up cells

I would need the to cells to add up everyday without me having to add it, how would I do that?

RE: to add up cells

try putting the totals cell at the top and entering the a sum for the colomn in question, i.e. =sum(first cell: 2000 cells down), something like =sum(b12:b2012) then pressing enter

Excel tip:

Select Single Data Marker

To select a single data marker in a chart, ie line, bar or column;
After you have pressed Ctrl+Click (to select the entire chart) you can press the Up or Down arrows to select a data series, then press the Left or Right arrow to select a data point within that series.

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.