Is there a way to do a =sum formula using font colors to include or exclude in the formula?
H Help Mar 28, 2007 #1 Is there a way to do a =sum formula using font colors to include or exclude in the formula?
P Peo Sjoblom Mar 28, 2007 #2 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
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
H Help Mar 29, 2007 #3 Thank you as I am not versed at all with VBA how do I save the vba information in order to use it?
P Peo Sjoblom Mar 29, 2007 #4 Try this info http://www.mvps.org/dmcritchie/excel/install.htm Regards, Peo Sjoblom
