Does Excel have a @grandtotal function like Lotus 123

D

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.
 
G

Gord Dibben

Excel has subtotal and grandtotal.

See under>Help "About SubTotals"


Gord Dibben MS Excel MVP
 
M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top