| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Does Excel have a @grandtotal function like Lotus 123
In switching from Lotus to Excel, there were a couple of Lotus @functions
that I used fequently. I liked the @subtotal and @grandtotal. The @subtotal works similar in Excel, but in Lotus, you could use the @grandtotal that would only add all the cells in a list that contained @subtotal in their formula. So, if a cell only had a number and no @subtotal, then it would not be added, but if it had @subtotal, it would be added. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I duplicate the Lotus 123 @rate function in Excel? | Excel Worksheet Functions | |||
| Lotus 123 @nsum function equivalent in excel(?) | Excel Worksheet Functions | |||
| making subtotals and grandtotal from multiple pages excel2000 | Excel Worksheet Functions | |||
| Converting Lotus function to Excel | Excel Worksheet Functions | |||
| In Excel what can I use for the XINDEX function from Lotus 123? | Excel Worksheet Functions | |||
Threaded Mode
