Sum By Color
 

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.

Sum By Color
 

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...

"Pattylb" wrote:

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.

Sum By Color
 

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
--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.



"Pattylb" wrote:

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.

Sum By Color
 

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

THanks for your help.

"Barb Reinhardt" wrote:

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
--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.



"Pattylb" wrote:

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.

Sum By Color
 

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

Thank again.

"Pattylb" wrote:

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

THanks for your help.

"Barb Reinhardt" wrote:

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
--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.



"Pattylb" wrote:

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.