how do I setup sum to add cells with same color format?

[KJow]

I have a worksheet that allows me to use formatsum, that is to add up all
cells with the same color format. But when i try to use the same formula on a
different spreadsheet, it didnt work and comes up as an error. Do I have to
setup the spreadsheet first to make it work?
formula is "formatsum(cell with target color,cell range)

 

[Jerry W. Lewis]

There is no native Excel function called "formatsum". It is apparently
available to your one worksheet as a user defined function. Since it does
not appear to be available elsewhere, it is probably in a VBA module attached
to the workbook where it is available. You will either need to copy the code
into every workbook that needs it, incorporate it into an Add-In, or put it
into your Personal.xls in the Xlstart folder.

This newsgroup deals with things that cause Excel to crash. Since Excel
rarely crashes, this newsgroup does not get a lot of traffic. You will get
much faster response if you post queries dealing with non crash-related
topics in a more appropriate newsgroup.

Jerry