View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
willwonka willwonka is offline
external usenet poster
 
Posts: 40
Default Sum Cells with colors

You can create a custom function using Chuck Pearson's website:

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

Or

I believe the new ASAP Utilities has a function for this.

http://www.asap-utilities.com/


taxmom wrote:
What formula can I use to sum at the bottom of the pages specific colors?

ex.

5.00 yellow
2.00 green
1.00 yellow
1.00 red
3.00 green

total green 5.00
Total Yellow 6.00
Total Red 1.00

Is this possible?

Thank you ! You are all so helpful.