| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF using color
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUMIF using color
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUMIF using color
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUMIF using color
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 |
|
#5
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sumif, criteria, fill color | Excel Discussion (Misc queries) | |||
| SUMIF function with text color condition | Excel Worksheet Functions | |||
| Sumif and base it on font color of cell | Excel Worksheet Functions | |||
| SUMIF on Fill color | Excel Worksheet Functions | |||
| SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions | |||
Hybrid Mode
