Friday again, time for #formulafriday.
You can download todays example here.
[wpdm_package id=’9896′]
Ok, so you are probably saying AUTOSUM, really?. Whats special about that then?. Yes we use it a lot- or I do whether is via Ribbon
- Home Tab
- Editing Group
- AutoSum
OR
use the KEYBOARD SHORTCUT ALT+=
But….it also can do really really cool stuff, not just sum your columns of data. How about when you have a data set that looks like this?.
Autosum will automatically sum your rows and columns in the same way as it does with just a column of data all at the same time!.
- Highlight the data set and the cells where you want to hold the summed values (I have highlighted the cell in green in my example).
- Use the Ribbon method or the keyboard shortcut to populate the cells with one click click.
Fast as that- how cool. Autosum packs a little more punch.
I hoped you like liked today’s #formulafriday.
Dont forget to sign up to the Excel at Excel Newletter for 3 free Excel tips the first Wednesday of the month. Just click on the Sign Up Form to the right or use the link below.