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

Great Thank you ! These are just what I'm looking for. I do some reading
and I'm sure I will find the answer.

Thanks again ! You all are the best ! : )

"willwonka" wrote:

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.