Thread: SUMIF function with text color condition
View Single Post
  #2   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
Visit Chip Pearson's site for working with colored cells.

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

See the SumByColor Function.


Gord Dibben MS Excel MVP


On Thu, 17 Aug 2006 18:43:02 -0700, 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.


Reply With QuoteReply With Quote