Total row doesn't work properly, Excel 2010

[Franky]

In my Excel 2010 file and in one of its sheets I have a small table. As following, when I checked the Total Row option in Table tools > Design > Table style options > Total Row the tabled appeared as follows. But it is against of the info when I hold the mouse pointer over the Total Row check box because that info says: The total row is a row at the end of the table which displays totals for each column. But in practice it only displays the total for the last column not each column! Any idea why?

 

[Ranger4]

Your problem is not all that clear, but from what I can see from your post, that one column results seem to be correct.

This is from Excel 2013, but I think they are very similar. If you want to total the other 2 columns then you need to carry out that procedure. If you click on the Totals row below each column & click on the Totals icon & select Sum, the column will highlight & the formula will show in the formula slot & the total for that column will be entered. Do this for each column. refer to screen shot.



Also if you click on the little arrow beside the Totals icon more alternatives are shown.

 

[Franky]

Yes you are right. Thank you.

 

[Ranger4]

Thanks for posting back. Glad to hear it helped.
Perhaps you could mark the problem as solved.