excel.training.course.london - Sum

Resolved · Low Priority · Version Standard

Wed 24 Oct 2007, 12:48 Delegate Rachel said...

Rachel has attended:
Excel Introduction course

Sum

What is the difference between entering a formula i.e =(b5+c5+d5) and using sum in a formula?

Wed 24 Oct 2007, 12:52 Delegate Paul said...

RE: Sum

sum is just easier.

if you have loads of cells that you want to add up next to each other, you don't want to type =B5+C5+D5 etc, you just type =sum(B5:D5) this will add up all the cells between and including B5 & D5

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Cycling through Absoulte cell references

If you are working with formulas in excel and need to convert your formula to an absolute formula, instead on manually adding in the $dollar signs you can highlight the specific part of your formula and press the F4 key.

You can cycle through all the absolute options by pressing the button (up to four times)

View all Excel hints and tips

Application Training

Training ProgramsProfessional & Management Development

eLearning Solutions

Our Promotions

Our Schedule

Course Formats

Our Clients

excel.training.course.london - Sum

Sum

RE: Sum

Excel articles

Excel tip:

Cycling through Absoulte cell references

Training Programs
Professional & Management Development