View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default SUMIF function with text color condition

Both or at least one of us is redundant<g


Gord

On Thu, 17 Aug 2006 21:13:45 -0500, Dave Peterson
wrote:

There's nothing built into excel that allows you to do this.

If you want a macro, you could use Chip Pearson's:
http://cpearson.com/excel/colors.htm

MrWallyWorld wrote:

I am creating a simple addition formula but I want my formula to only count
numbers in corresponding row from text in the color blue(or red, green,
etc.). Help would be much appreciatted.