Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum the ranges
Please help...
i have a range F1:H100, i would like to sum with this criteria Column A, starting from F1:F12, the formula at F105 Column B, starting from G5:G17, the formula at G105 Column C, starting from H20:H32, the formula at H105 Basically, i would like to sum for total 12Rows, but different unique start of Row number? Thank you and TIA |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum the ranges
Just to clarify ...
Could F105 contain any range of 12 rows from F1 onwards e.g. F10:F21? Or have I completely misunderstood? "Andri" wrote: Please help... i have a range F1:H100, i would like to sum with this criteria Column A, starting from F1:F12, the formula at F105 Column B, starting from G5:G17, the formula at G105 Column C, starting from H20:H32, the formula at H105 Basically, i would like to sum for total 12Rows, but different unique start of Row number? Thank you and TIA |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum the ranges
No, F105, only contains F1 to F12...
then later i plan to entry at F106...to sum from F13 to F24... the same with G105 and H105.... Thank for the response.. "Toppers" wrote: Just to clarify ... Could F105 contain any range of 12 rows from F1 onwards e.g. F10:F21? Or have I completely misunderstood? "Andri" wrote: Please help... i have a range F1:H100, i would like to sum with this criteria Column A, starting from F1:F12, the formula at F105 Column B, starting from G5:G17, the formula at G105 Column C, starting from H20:H32, the formula at H105 Basically, i would like to sum for total 12Rows, but different unique start of Row number? Thank you and TIA |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum the ranges
Try (and copy down):
in F105 =SUM(OFFSET($F$1,(ROW()-105)*12,0,12)) Similar logic for G & H "Andri" wrote: No, F105, only contains F1 to F12... then later i plan to entry at F106...to sum from F13 to F24... the same with G105 and H105.... Thank for the response.. "Toppers" wrote: Just to clarify ... Could F105 contain any range of 12 rows from F1 onwards e.g. F10:F21? Or have I completely misunderstood? "Andri" wrote: Please help... i have a range F1:H100, i would like to sum with this criteria Column A, starting from F1:F12, the formula at F105 Column B, starting from G5:G17, the formula at G105 Column C, starting from H20:H32, the formula at H105 Basically, i would like to sum for total 12Rows, but different unique start of Row number? Thank you and TIA |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum the ranges
Thank you, it is workable....and solving my weekend case...
"Toppers" wrote: Try (and copy down): in F105 =SUM(OFFSET($F$1,(ROW()-105)*12,0,12)) Similar logic for G & H "Andri" wrote: No, F105, only contains F1 to F12... then later i plan to entry at F106...to sum from F13 to F24... the same with G105 and H105.... Thank for the response.. "Toppers" wrote: Just to clarify ... Could F105 contain any range of 12 rows from F1 onwards e.g. F10:F21? Or have I completely misunderstood? "Andri" wrote: Please help... i have a range F1:H100, i would like to sum with this criteria Column A, starting from F1:F12, the formula at F105 Column B, starting from G5:G17, the formula at G105 Column C, starting from H20:H32, the formula at H105 Basically, i would like to sum for total 12Rows, but different unique start of Row number? Thank you and TIA |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum the ranges
Glad it's working ... have a good (rest of) weekend.
"Andri" wrote: Thank you, it is workable....and solving my weekend case... "Toppers" wrote: Try (and copy down): in F105 =SUM(OFFSET($F$1,(ROW()-105)*12,0,12)) Similar logic for G & H "Andri" wrote: No, F105, only contains F1 to F12... then later i plan to entry at F106...to sum from F13 to F24... the same with G105 and H105.... Thank for the response.. "Toppers" wrote: Just to clarify ... Could F105 contain any range of 12 rows from F1 onwards e.g. F10:F21? Or have I completely misunderstood? "Andri" wrote: Please help... i have a range F1:H100, i would like to sum with this criteria Column A, starting from F1:F12, the formula at F105 Column B, starting from G5:G17, the formula at G105 Column C, starting from H20:H32, the formula at H105 Basically, i would like to sum for total 12Rows, but different unique start of Row number? Thank you and TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum Ranges | Excel Worksheet Functions | |||
ranges | Excel Discussion (Misc queries) | |||
3D Ranges | Excel Worksheet Functions | |||
Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) | |||
Sum ranges | Excel Worksheet Functions |