# 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

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

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