| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to count the number of cells it takes to reach a certain sum
I have a row of data and it contains numerical values. What I want to be able
to do is put a 1 above one of the values and the cell above the one will count how many cells back it takes for the sum of the values to get a certain value. Ex I want to count how many cells it takes to get to over a sum of 300. A B C D E F G H I J K 1 8 2 1 3 25 40 55 35 40 60 55 20 15 50 40 since 40+50+15+20+55+60+40+35=315 it takes 8 cells to get over a value of 315 Any help will be great. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sum of cells until reach empty cell | Excel Worksheet Functions | |||
| I cannot reach the next cells in the xls worksheet | Excel Worksheet Functions | |||
| Count Number of Different Cells | Excel Worksheet Functions | |||
| I need to add a range of cells until I reach a cell with a zero va | Excel Worksheet Functions | |||
| Count number to reach a cumulative value | Excel Worksheet Functions | |||
Threaded Mode
