excel advanced - Formaulas

Resolved · Low Priority · Version Standard

Formaulas

James has attended:
Excel Introduction course

by - delegate James [1 post] (2007 Sep 24 Mon, 10:00) Reply

Sum total of a column

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 3 Wed	Bloomsbury	0	FULL
2003	2008 Dec 5 Fri	Bayswater	1	book now	£195	£205
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	6	book now	£214	£230
Full Schedule: See all 96 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: formaulas

by - delegate Paul gold contributer [121 posts] (2007 Sep 24 Mon, 14:39) Reply

=SUM(A:A)

(this has to be written in a cell that is not in column A)

· Advanced Excel Training - takes you to the next level
· Identifying Suitable Candidates For VBA For Excel Training
· Microsoft Excel Training - Numerical excellence for all
· Excel and Inventory Management
· Tools From Advanced Excel Courses: Goal Seek and Solver

Excel tip:

Converting an American date format to European using Formula

Excel depending on your local setting will only pick up date values of the dd mmm yyyy oders as date type. If you import data from various sources including America their date order is different with data value in mmm dd yyyy, excel can only treat it as text indicated by left aligning it. To overcome this you have to do the the following.

1. Extract the date components mmm dd yyyy, by using the the Text functions LEFT, MID or RIGHT

2. Reorder dd mmm component and concatenate using "&" in the right order this will create a text string with the date in the right order it then needss to be converted to a value so excel can recognise it.

3. To convert to value encase in TEXT function.

4. Format to desired date format.

View all Excel hints and tips

Rate this page: