Excel Magic Trick #236: Excel For Home Improvement

[MrHelal123]

if you see the 3:10 mark, you will see a drop own box next to the total, you can change to subtotal to whatever function. If you have a look at your workbook you will see you can change the subtotal to average, count, sum etc...

Thanks

[ExcelIsFun]

If you data is set up with field names in the first row and records in al the other rows and no blanks, use Ctrl + T (2003 Ctrl + L) to convert to table, then Alt + = in cell below last row and the subtotal row will be added automatically. Or if in 2007, you can use ribbon to add total row.

[MrHelal123]

Thank you for all your support

How did you manage to change the subtotal to change to count, sum, average etc...there is a drop down list so that i could change to what ever function but its not done by data validation, how did you do it?

Thank you

[ExcelIsFun]

What minute mark?

You might try this video:

Highline Excel Class 46: CHOOSE function 4 Examples

[Oakley578]

1st comment!!