Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lotus 123 @nsum function equivalent in excel(?)
I have an old lotus 123 spreadsheet (a budget) that used the @nsum function.
It allowed me to sum every third or forth column. The text below shows the syntax. My question... does excel have a function like this? Adds every nth value in list, starting at offset. Syntax @NSUM returns the sum of (offset), (offset + n), (offset + 2n), (offset + 3n), ... in list. @NSUM(0;1;list) returns the same result as @SUM(list). Example @NSUM(1;3;B5..B15) returns the sum of the values in B6, B9, B12 and B15. Thanks in advance, mh |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lotus 123 @Regression the equivalent in Excel? | Excel Worksheet Functions | |||
Is there an equivalent of Lotus 123's "Paste visible" command? | Excel Discussion (Misc queries) | |||
Delete a row and inset a row - Lotus equivalent | Setting up and Configuration of Excel | |||
what is the excel equivalent to lotus backsolve | Excel Worksheet Functions | |||
Lotus Equivalent | Excel Discussion (Misc queries) |