Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding values in first "X" number of rows dynamically
Hi -
I have a data worksheet which has item sub-totals in column F (each row is a different item). In a different worksheet, I have a a few other calculations going on, to determine # of resources available (this will vary, based on data entered elsewhere). What I'd like to be able to do is only add the sub-totals from "X" number of rows, depending on the # of resources available (which can change). So, for example, if I've determined to have 10 resources available, I'd like to only calculate/sum the sub-totals from the first 10 rows. However, if this changed to 12 resources, I'd like to be able to dynamically come up with a total from the first 12 rows instead. Does that make sense (and is something like that possible, in Excel ?) Any ideas would be most appreciated ! Thanks for your help, - Matt |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding values generated by "IF" Statement | Excel Discussion (Misc queries) | |||
Adding 2 Values When 3 Conditions are Met, Including an "OR" | Excel Worksheet Functions | |||
"Adding" rows from one workbook to another, and expanding workbooks by row | Excel Discussion (Misc queries) | |||
GETPIVOTDATA question regarding adding "rows" | Excel Worksheet Functions | |||
Changing "returned" values from "0" to "blank" | Excel Worksheet Functions |