Adding highlighted cells only -Excel 2000

[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

 

[Gord Dibben]

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

 

[ebloch]

The free ASAP Utilities has functions that sum by Text Color or Cell Color.

Eric