View Single Post
  #3  
Old November 12th, 2009, 05:27 PM posted to microsoft.public.excel.misc
T. Valko
external usenet poster
 
Posts: 15,759
Default Excel 2003 had a function to "SumByColor" -- it's not in 2007?

Excel 2003 did not have any built-in functions to do this. You may have had
a user defined function or an add-in with a function that did this.

See this:

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

Make sure you read the section titled: Color Change And Calculation

--
Biff
Microsoft Excel MVP


"Becky" wrote in message
...
Excel 2003 had a function to "SumByColor", I don't see that function in
Office 2007. Does anyone know a replacement, or how to do the same type
of
thing?