Formula Question
 

Is there a way to do a =sum formula using font colors to include or exclude
in the formula?

Formula Question
 

If you have Excel 2007 you can filter on colour then use the subtotal
function to sum the visible cells, In previous versions you need to roll
your own function

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



Regards,


Peo Sjoblom


"Help" wrote in message
...
Is there a way to do a =sum formula using font colors to include or
exclude
in the formula?

Formula Question
 

Thank you as I am not versed at all with VBA how do I save the vba
information in order to use it?

"Peo Sjoblom" wrote:

If you have Excel 2007 you can filter on colour then use the subtotal
function to sum the visible cells, In previous versions you need to roll
your own function

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



Regards,


Peo Sjoblom


"Help" wrote in message
...
Is there a way to do a =sum formula using font colors to include or
exclude
in the formula?

Formula Question
 

Try this info

http://www.mvps.org/dmcritchie/excel/install.htm


Regards,

Peo Sjoblom


"Help" wrote in message
...
Thank you as I am not versed at all with VBA how do I save the vba
information in order to use it?

"Peo Sjoblom" wrote:

If you have Excel 2007 you can filter on colour then use the subtotal
function to sum the visible cells, In previous versions you need to roll
your own function

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



Regards,


Peo Sjoblom


"Help" wrote in message
...
Is there a way to do a =sum formula using font colors to include or
exclude
in the formula?