+ Reply to Thread
Results 1 to 4 of 4

Adding Totals in a worksheet

  1. #1
    Registered User
    Join Date
    04-10-2008
    Posts
    11

    Adding Totals in a worksheet

    I've 39 number totals in a column that I need to add up and show an "overall total" at the bottom of the sheet. I know that I can't use more than 30 functions, but I can't use the colon either because there are numbers between the totals that I don't need to count. The totals are formated with a grey cell. I didn't know if there was a way I could identify the column and then the formatting of the cell to add those values. Any help is greatly appreciated

  2. #2
    Registered User
    Join Date
    04-17-2008
    Posts
    29
    Can you upload the Excel file? Perhaps I can help you then.

  3. #3
    Registered User
    Join Date
    04-10-2008
    Posts
    11
    This is the formula that does not work because there are too many cells to calculate. How do I do this?

    Results would be in cell E259



    =sum(E18,E33,E51,E58,E66,E74,E82,E89,E95,E101,E107,E112,E116,E120,E125,E129,E137,E143,E149,E156,E161,E167,E171,E177,E182,E187,E192,E197,E202,E207,E213,E222,E228,E233,E239,E244,E250,E255,E258)

  4. #4
    Registered User
    Join Date
    04-10-2008
    Posts
    11
    Ahh yes.... =sum()/2

    Duh!!!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1