| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using cell reference in a formula instead of the obtained value
Hi
I have some values for a peak. Time Area 7.539 1148928 7.543 1524224 7.547 1943040 7.551 2370560 7.555 2814464 7.559 3253760 7.563 3657728 7.567 4047360 7.571 4366848 7.574 4544512 7.578 4646400 7.582 4617216 7.586 4493312 7.59 4291584 7.594 3965952 7.598 3555328 7.602 3117568 7.606 2692608 7.61 2278912 7.613 1879552 7.617 1534976 7.621 1243136 7.625 1017664 My problem is to find out the MAX() from Area column. Once the maximum value is obtained (here it is 4646400), I need to add up the next ten rows (sum comes to 32427008). I would like to execute in a single formula. I tried to use OFFSET with MAX formula but did not work. Your help is highly appreciated, Thanks and Regds, Kombu |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using a cell reference within a cell reference in a formula | Excel Worksheet Functions | |||
| Replacing #N/A response when obtained in Lookup function | Excel Worksheet Functions | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
| What is Multiple R, it is the first solution obtained in Regressi. | Excel Worksheet Functions | |||
| What is Multiple R, it is the first solution obtained in Regressi. | Excel Worksheet Functions | |||
Threaded Mode
