# Adding Totals in a worksheet

1. ## 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. Can you upload the Excel file? Perhaps I can help you then.

3. 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. Ahh yes.... =sum()/2

Duh!!!!!

#### Thread Information

##### Users Browsing this Thread

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

#### 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