| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
summing last values in column
Anything wrong with my suggestion?
-- Regards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- "gotta know" wrote in message ups.com... *EDIT... Yes it does give me a circular reference. I moved to column B. This forumula gives me the sum of values in A2:A20, not the last 25 periods in column A. =SUM(LARGE(A2:A20,ROW(INDIRECT("1:"&MIN(COUNT(A:A) ,25))))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| summing values in a data table based on criteria in another column | Excel Worksheet Functions | |||
| How to match values in one column to values in another? | Excel Worksheet Functions | |||
| Conditional Format as a MACRO | Excel Worksheet Functions | |||
| summing values from adjacent column with refrence from adjacent column | Excel Discussion (Misc queries) | |||
| Lookup values in one column to return another | Excel Worksheet Functions | |||
Threaded Mode
