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
Can you upload the Excel file? Perhaps I can help you then.
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
Ahh yes.... =sum()/2
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
- 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