Adding Totals in a worksheet

[josterfeld]

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

[mick02]

Can you upload the Excel file? Perhaps I can help you then.

[josterfeld]

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)

[josterfeld]

Ahh yes.... =sum()/2

Duh!!!!!