# Calculating the 3 highest numbers in a column

#### Mary G

##### New Member
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?

### Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
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})) ?

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}))

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.

Replies
1
Views
259
Replies
1
Views
173
Replies
9
Views
213
Replies
2
Views
154
Replies
1
Views
99

1,221,425
Messages
6,159,831
Members
451,592
Latest member

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back