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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
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
 
Back
Top