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

excel 2003 visual basic intermediate course - microsoft excel introduction

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel 2003 visual basic intermediate course - Microsoft Excel Introduction

excel 2003 visual basic intermediate course - Microsoft Excel Introduction

ResolvedVersion Standard

Simon has attended:
Excel Introduction course

Microsoft Excel Introduction

How would I sum up figures in cells in a row?

RE: Microsoft Excel Introduction

Hi Simon
hope you are well, there many ways to sum up figures all you would need to do is either type up a formula for example
in the blank cell under the figures: =b3+b4+b5+b6+b7 and press enter or you could also try any of the following

You could type the following formula as follows using the cell references that you need: =sum(b3:b7) in the blank cell where you answer needs to go, or you could clink on the blank cell the go to the AUTOSUM toolbar button which looks like this ∑ you can also do other formulas such as average, min and max by replace the word SUM with arevage which would look like this =average(b3:b7)

hope this helps

Mark East

Excel tip:

Editing Formulas in Excel Cells

Although people like to edit a formula in the Formula bar, you can also edit a formula in the cell.

To do this select the cell and press "F2". This puts Excel into Edit mode, and you can move around in the cell and make any necessary changes.

Double-clicking the cell also puts Excel in Edit mode.

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.12 secs.