Adding highlighted cells only -Excel 2000

  • Thread starter Thread starter geo.nova
  • Start date Start date
G

geo.nova

Anyone know if there is a way to add only cells that are highlighted?
I would like to see quick sums of only the cells I have highlighted
and hoping there might be a way to do this quickly and easily. I have
to do this many times with various cells with differing number values.
Thanks in advance
K
 
By "highlighted" do you mean colored or simply selected?

If the latter, use the Sum on the Status Bar.

If the former.....................

You will have to use VBA to grab the colorindex of the cells.

Do you want to do that?

See Chip Pearson's site for UDF's for working with colorindex.

http://www.cpearson.com/excel/colors.aspx


Gord Dibben MS Excel MVP
 
Back
Top