Thread: SUMIF function with text color condition
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default SUMIF function with text color condition
From the Department of Redundancy Department?



Gord Dibben wrote:

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.

--

Dave Peterson
Reply With QuoteReply With Quote