I have a spreadsheet that I have multiple columns and I sum each one for a total but I have colored cells within these columns and they need to be subtracted or make them not be figured in at all. Have attached a sample.
Thank you
I have a spreadsheet that I have multiple columns and I sum each one for a total but I have colored cells within these columns and they need to be subtracted or make them not be figured in at all. Have attached a sample.
Thank you
replace all of your =sum() with =subtotal(9,range) the 9 is to add
then for the grand total, use subtotal(9,range) for the entire range
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
USE FORMULA IN C40 CELL AND DRAG.
NOTE:A10 cell is blank. I feel you have to fill sum number .Then only formula works ok.
Please Login or Register to view this content.
Last edited by kvsrinivasamurthy; 01-17-2013 at 12:00 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks