I have some financial data in Excel 2007 and I highlight certain cells (using the "fill" command), not based on the value, but other factors that only I would recognize. I want to make a function in another cell that will either return the sum of all highlighted cells within the specified column, or more specifically "return the sum of all cells in the range that are NOT highlighted blue" for example. Thank you!
Can I make an Excel 2007 function to only add or to exclude certain highlighted cells?
- Thread starter Travis
- Start date