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 Edit>Find>Format>Pattern. 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