Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumproduct last 30 rows
How can I use sumproduct on the last 30 rows of a database whose number of
rows changes daily? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumproduct last 30 rows
Assuming your headings are in row 1 and data start from row 2 and
down. To sum column C:C, one way: =SUMPRODUCT(OFFSET(C1,COUNTA(C:C)-29,0,30,)) HTH Kostis Vezerides On Jul 3, 3:58 pm, Nick Krill wrote: How can I use sumproduct on the last 30 rows of a database whose number of rows changes daily? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumproduct last 30 rows
Assume your data in column A and header in row1, and no "blank" cells in
between the data =SUM(OFFSET(A2,COUNT(A:A)-1,,-30,1)) "Nick Krill" wrote: How can I use sumproduct on the last 30 rows of a database whose number of rows changes daily? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRODUCT - Ignore blank rows | Excel Worksheet Functions | |||
SUMPRODUCT with varying # of rows | Excel Worksheet Functions | |||
Excel 2003 -Rows hidden. Scrolling unhides rows ! How do I stop th | Excel Discussion (Misc queries) | |||
Pivot Tables: How do I show ALL field rows, including empty rows?? | Excel Worksheet Functions | |||
sumproduct and even numbered rows | Excel Discussion (Misc queries) |