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.

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.

You do the =subtotal function for the small sub-sets, and then do =subtoal for the entire column.

i.e.

1
1
=subtotal(9,a1..a2)2
2
2
=subtotal(9,a4..a5)4
=subtotal(9,a1..a5)6



daedconc0 wrote:

Does Excel have a @grandtotal function like Lotus 123
25-Aug-09

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.

EggHeadCafe - Software Developer Portal of Choice
WPF DataGrid Custom Paging and Sorting
http://www.eggheadcafe.com/tutorials...tom-pagin.aspx