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

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formulas

Formulas

ResolvedVersion 2003

Wed 18 Jun 2008, 08:47 Delegate Keith said...

Keith has attended:
Excel Advanced course

Formulas

How do I link formulas between several worksheets to populate a summary sheet

Wed 18 Jun 2008, 15:11 Trainer David said...

RE: Formulas

Hi Keith

Firstly go into your summary sheet and select the cell that you want your formula to appear. Type = and then click through to the sheet the formula appears in and then click on the cell. Finally hit the enter key and the cell in your summary sheet will update automatically with the info in that sheet.

Lets say I wanted the info contained in Sheet 2 cell A1 to be copied into Sheet 1 cell A1 as my summary sheet. My formula in Sheet 1 cell A1 would be : =Sheet2!A1

Hope that helps
David

Excel tip:

LARGE and SMALL functions and their uses

Two of Excel's most common functions are the MAX and MIN functions which will display the largest (MAX) or smallest (MIN) value in a series. What if you need the 2nd or 3rd largest or smallest values instead of the largest or smallest?

The =LARGE(array,n) returns the nth largest value of a series.

The =SMALL(array,n) function returns the nth smallest value of a series.

In both functions, 'n' represents the order of the number you want to display. For example, putting in 2 as n will give you the second highest number; putting in 3 as n will give you the third highest number.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Formulas

Formulas

RE: Formulas

Excel articles

Excel tip:

LARGE and SMALL functions and their uses