Calculating the 3 highest numbers in a column

[Mary G]

In a spreadsheet of sports scores for different teams (team names in a column down the left and game dates across top row)is it possible to have the 3 highest team scores total automatically at the bottom for each date?

 

[Aladin Akyurek]

On 2002-09-24 08:34, Mary G wrote:
In a spreadsheet of sports scores for different teams (team names in a column down the left and game dates across top row)is it possible to have the 3 highest team scores total automatically at the bottom for each date?

=SUM(LARGE(Range,{1,2,3})) ?

 

[Dave Patton]

On 2002-09-24 08:34, Mary G wrote:
In a spreadsheet of sports scores for different teams (team names in a column down the left and game dates across top row)is it possible to have the 3 highest team scores total automatically at the bottom for each date?

The following will give total of 3 largest in range

=SUM(LARGE(B2:B19,{1,2,3}))

Adjust the range as necessary.

Copy the formula across.

This gives one total. Please provide additional information if this is not what you require.

They may be having technical problems with MrExcel.com so I will review posts late tonight.