| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding actual cells in a function
Hello,
I am trying to design a formula to add cells together when another condition is met but am struggling. A B 1 10 2 2 7 3 9 What I need is a formula that subtotals X amount of rows when a condition is met. So in the example, when B11 I want the formula to add cells A1+1 (e.g. cells A1:A2). This is for a very large database and the values for B vary considerably, and I wondered whether there was a way of using a formula to add cells to a current cell reference. Like A1+(1 cell). Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding actual cells in a function
Maybe something like:
=SUM(OFFSET(A1,0,0,B1+1,1)) richardwo wrote: Hello, I am trying to design a formula to add cells together when another condition is met but am struggling. A B 1 10 2 2 7 3 9 What I need is a formula that subtotals X amount of rows when a condition is met. So in the example, when B11 I want the formula to add cells A1+1 (e.g. cells A1:A2). This is for a very large database and the values for B vary considerably, and I wondered whether there was a way of using a formula to add cells to a current cell reference. Like A1+(1 cell). Thanks -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding actual Cells | Excel Discussion (Misc queries) | |||
| Count blank cells containing function | Excel Discussion (Misc queries) | |||
| a function that counts the number of cells with information | Excel Worksheet Functions | |||
| a function that counts the amount of cells with information in them | Excel Discussion (Misc queries) | |||
| Use TREND function with nonadjacent cells | Excel Worksheet Functions | |||
Linear Mode
