Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Sum Based on Cell location in Column
An Excel dilemma...
I have a sheet that is updated from another program and it fills the column with numbers that start randomly based on time somewhere between 1 and 600 rows... that is... the data can start at row 256 and continue to 600 or at any other row. I would like to SUM the first 30 Rows when the data starts Automatically coming in. Example First Update Second Update Row Column Row Column 1 0 1 0 2 0 2 0 3 24 3 0 4 36 4 0 5 42 5 20 6 55 6 55 7 44 7 22 8 55 8 55 I will be opening the spreadsheet and it will auto update, I just want the SUM to auto update based on the criteria. I figured it might be a SUM IF, COUNT OR ARRAY Please Help..... MY head hurts. |
#2
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Sum Based on Cell location in Column
Hi
try the following array formula (entered with CTRL+SHIFT+ENTER): =SUM(OFFSET($A$1,MIN(IF($A$1:$A$1000<"",ROW($A$1: $A$1000)))-1,0,30)) -- Regards Frank Kabel Frankfurt, Germany "Bill King" schrieb im Newsbeitrag om... An Excel dilemma... I have a sheet that is updated from another program and it fills the column with numbers that start randomly based on time somewhere between 1 and 600 rows... that is... the data can start at row 256 and continue to 600 or at any other row. I would like to SUM the first 30 Rows when the data starts Automatically coming in. Example First Update Second Update Row Column Row Column 1 0 1 0 2 0 2 0 3 24 3 0 4 36 4 0 5 42 5 20 6 55 6 55 7 44 7 22 8 55 8 55 I will be opening the spreadsheet and it will auto update, I just want the SUM to auto update based on the criteria. I figured it might be a SUM IF, COUNT OR ARRAY Please Help..... MY head hurts. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Show value from specific column based on location of active cell | Excel Discussion (Misc queries) | |||
Looking up 3 cells based on defined value in a row/column location | Excel Worksheet Functions | |||
Location of the Last cell in a column containing data | Excel Discussion (Misc queries) | |||
Hide column or row based on a cell in the column or row? | Excel Discussion (Misc queries) | |||
Deleting Rows based on text in cell & formatting cell based on text in column beside it | Excel Programming |