Excel++Totals+etc.


 * Excel Totals etc. **

** When you have created your table choose which ever row you wish to have a total at the bottom ** you need to select a cell in the total row, you will notice there is a **Down Arrow on the Right-Hand Side** **click this and that creates a** drop down list From that list, you can **select** **what kind of result you wish to display**. There are quite a selection.
 * There is a simple and quick way of attaining the sum total of a column, instead of creating a formulae. **

You will need the **Table Tools Design tab** that opens when the table is selected. Inthe **Design** tab, use the **Table Style Options** section. Select the **Total Row** checkbox. Now this will turn the example from this:- To this:

In the example it only displays the sum in the end column, that is because the chosen cell was in the end column. You can select whatever you desire the choice is yours, because Excel automatically uses all the data in the column above the total row, and creates the formula after you have instructed it which one to use. Play with this and enjoy the results.

However, it does not work on all versions, so my apologies for your frustration.