Sum By Color

[Pattylb]

Did this function disappear in Excel 2007? I have a worksheet from Excel
2003 using this function. When I open it in Excel 2007, I get the #NAME
error. All add-in's have been loaded, so I don't think that's the issue.
Thank you.

 

[Sean Timmons]

Don't think thats a 2003 function either.

Someone may have created some VB code in the backgroudn to create this
function within the workbook...

 

[Barb Reinhardt]

I'm not aware of a Sum By Color function in native Excel 2003. I have seen
functions built by other that do this. I'm thinking you'll find something
here

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

 

[Pattylb]

You're right. I did use some VBA code. But new Excel should recognize that,
no?

THanks for your help.

 

[Pattylb]

I'm so sorry; I'm not thinking. I had to change the security settings in
order for the code to run.

Thank again.