excel-xp-training

excel-xp-training - Formulas

Resolved · Low Priority · Version Standard

Formulas

Kim has attended:
Excel Intermediate course

by - delegate Kim [2 posts] (2008 Jan 24 Thu, 09:51) Reply

How do you make the columns total

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 5 Fri	Bayswater	0	FULL
2002/XP	2008 Dec 10 Wed	Tooting	0	FULL
2003	2008 Dec 10 Wed	Bloomsbury	0	FULL
2007	2008 Dec 10 Wed	Bloomsbury	2	book now	£240	£245
2003	2008 Dec 12 Fri	Southwark	4	book now	£224	£235
2003	2008 Dec 17 Wed	Southwark	1	book now	£235	£240
Full Schedule: See all 95 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Formulas

by - trainer Mark gold contributer [275 posts] (2008 Feb 1 Fri, 12:00) Reply

Hi Kim

Sorry we have not got back to you sooner 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