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.