View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mshaw1515 mshaw1515 is offline
external usenet poster
 
Posts: 1
Default SUMIF using color

I need a totally idiot proof guide to doing this. I tried pasting
'=SUMPRODUCT(--(ColorIndex(A1:A100)=3))' into a cell and chanign the 3 to 6
which i beleive value for yellow. All I get is #NAME?. Does this work in
Excel 2007? Do i need to enable something? Do i need to paste this code
into VBL?

Any help would be GREATLY appreciated!


"Bob Phillips" wrote:

See http://www.xldynamic.com/source/xld.ColourCounter.html for a working
solution

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Klee" wrote in message
...
Is there a way to only add cells in a column that have a certain colored
font? I looked at the link at http://www.cpearson.com/excel/colors.htm but
I
couldn't figure out if this can be done or not.

What I need specifically is a way to say: add G100 plus any numbers that
are
blue from G1:G99.

Thanks in advance,
Kris