Does Excel have a @grandtotal function like Lotus 123

[daedconc04]

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.

 

[Gord Dibben]

Excel has subtotal and grandtotal.

See under>Help "About SubTotals"


Gord Dibben MS Excel MVP

 

[Me Haney]

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/tutorial...f-32b2d802ae17/wpf-datagrid-custom-pagin.aspx