|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
SUMIF using color
Oh, Now I get it, thanks!
"Bob Phillips" wrote:
As I said to you, because you set the text argument to TRUE in the
ColorIndex function call, you were not testing coloured cells, but coloured
text within those cells!!!
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Klee" wrote in message
...
Thanks so much for all of your help. I don't know what I was doing wrong
but
it was driving me crazy so I gave up and went with the helper column to
add
the colored cells.
Thanks again. Kris
"Bob Phillips" wrote:
Assuming that you have copied the ColorIndex function in correctly, the
formula should work. I have just reconstructed it and it works fine. You
appreciate that your formula is summing the yellow NUMBERS in F3:F74?
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my
addy)
"Klee" wrote in message
...
Hi Bob,
I went to the site and copied the code at the bottom. I went into
toolsmacrosVBA then into InsertModuleand pased the code. Then I used
the
following formula:
=SUMPRODUCT(--(ColorIndex(f3:f74,true)=6),f3:f74)
When I hit enter nothing happens. The formula is still just written in
the
cell. When I evaluate the formula it just says "the cell currently
being
evaluated contains a constant".
I have no idea what I'm doing wrong as this is way beyond my excel
skills.
Do you have any thoughts?
"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
|