| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
summing part of data range
Hi Guys
I have a spreadsheet with 8 columns of data and multiple rows For each row I want to sum the 7 highest values in the range of 8 values. Cna anyone advise the function/formula/syntax i need to use ? -- thanks Roy |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
summing part of data range
=SUM(A1:H1)-MIN(A1:H1)
hope this helps. "Roy Gudgeon" wrote in message ... Hi Guys I have a spreadsheet with 8 columns of data and multiple rows For each row I want to sum the 7 highest values in the range of 8 values. Cna anyone advise the function/formula/syntax i need to use ? -- thanks Roy |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
summing part of data range
easy when you know how....
cheers for prompt reply and solution -- thanks Roy "Gaurav" wrote: =SUM(A1:H1)-MIN(A1:H1) hope this helps. "Roy Gudgeon" wrote in message ... Hi Guys I have a spreadsheet with 8 columns of data and multiple rows For each row I want to sum the 7 highest values in the range of 8 values. Cna anyone advise the function/formula/syntax i need to use ? -- thanks Roy |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
summing part of data range
Glad it worked.
Thanks Gaurav "Roy Gudgeon" wrote in message ... easy when you know how.... cheers for prompt reply and solution -- thanks Roy "Gaurav" wrote: =SUM(A1:H1)-MIN(A1:H1) hope this helps. "Roy Gudgeon" wrote in message ... Hi Guys I have a spreadsheet with 8 columns of data and multiple rows For each row I want to sum the 7 highest values in the range of 8 values. Cna anyone advise the function/formula/syntax i need to use ? -- thanks Roy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summing up range of data | Excel Worksheet Functions | |||
| Find part data in row range? | Excel Worksheet Functions | |||
| summing part of a string, excluding cells | Excel Worksheet Functions | |||
| Summing part of an Alpha Numeric String | Excel Worksheet Functions | |||
| summing part of cells in a range | Excel Discussion (Misc queries) | |||
![Roy Gudgeon[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
