Does Excel have a @grandtotal function like Lotus 123
Excel has subtotal and grandtotal.
See underHelp "About SubTotals"
Gord Dibben MS Excel MVP
On Tue, 25 Aug 2009 14:03:01 -0700, daedconc04
wrote:
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.
|