Yes colored. I have a column of cells and i color them yellow with the fill
color button. Now I want to the sum of only the yellow cells, and if I color
more cells in the same column I want them to be totaled also.
"Gord Dibben" wrote:
What do you consider "highlighted"? Colored cells?
You would need to use VBA to SUM colored cells.
http://www.cpearson.com/excel/colors.aspx
If the cells are colored due to Conditional Formatting you could SUM based upon
the CF criteria.
If you just want to get a SUM on the Status Bar try the following method if you
have Excel 2003 and all colored cells are same color...............
Select the column then EditFindFormatPattern. Select the pattern and OK.
In the Found Dialog hit SHIFT + DownArrow
On Status Bar see SUM = xxx
Gord Dibben MS Excel MVP
On Wed, 19 Mar 2008 16:40:00 -0700, ac experts <ac
wrote:
Is there a formula to add the sum of all highlighted cells only in a column
with both no fill and highlighted cells.