Total row doesn't work properly, Excel 2010


  1. Franky
    Posts : 472
    windows 7 32-bit
       New #1

    Total row doesn't work properly, Excel 2010


    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?
    Attached Thumbnails Attached Thumbnails Total row doesn't work properly, Excel 2010-rld4q.png  
      My Computer
    Quote Quote

  3. Ranger4
    Posts : 9,746
    Windows 7 Home Premium 64 bit sp1
       New #2

    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.

    Total row doesn't work properly, Excel 2010-excel_column_totals..png

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

  4. Franky
    Posts : 472
    windows 7 32-bit
    Thread Starter
       New #3

    Yes you are right. Thank you.:)
      My Computer
    Quote Quote

  6. Ranger4
    Posts : 9,746
    Windows 7 Home Premium 64 bit sp1
       New #4

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

 

  Related Discussions
In my Excel 2010 workbook I wen through File > Info > Check for Issues > Inspect document. But as it's shown following, it doesn't show anything. Why? Thanks in advance.
Hi all, I have a small table and want to copy it after filtering. The image is in below (image no. 1), and I have filtered it to shows only the red font color of the column "Days" as follows, (image no. 2). Now everything is ready to start the copying! So I select all the table (Double CTRL+A...
Hello all, First I made some contents and drew a border from Home > Font > all Borders on an Excel 2010 file. So it became like below image (capture1). After that I wanted to print it so went to File > Print to see its preview. But the problem is that the lines between tue and wed and also...
Hi there When logging on to a service that needs extra logon Information such as supplying password etc IE9 fails. I'm currently in France and have to use the ORANGE France wifi service. IE8 gives me an orange logon screen -- works fine IE9 doesn't present the option -- I just get...
I have found several issue on excel now I'm using windows 7. When you select multiple cells, using control, they aren't highlighted. I also have issues with excel crashing all the time, even on relatively small files and running on a 8Gb machine Anyone else having the same issues?
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

 © Designer Media Ltd
All times are GMT -5. The time now is 12:51.
Find Us