| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using SUMIF function and conditional formatting
Hi,
I have a column of mumbers in which few numbers are filled with blue color, can I give a formula to add the cells that are colored? -- Regards, Malini S |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using SUMIF function and conditional formatting
Hi,
You can't sum by colours with a formula, you need a macro, but you can sum by the conditional format that set the colour. If you post the conditional format then someone will help. Mike "BSM" wrote: Hi, I have a column of mumbers in which few numbers are filled with blue color, can I give a formula to add the cells that are colored? -- Regards, Malini S |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using SUMIF function and conditional formatting
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) "BSM" wrote in message ... Hi, I have a column of mumbers in which few numbers are filled with blue color, can I give a formula to add the cells that are colored? -- Regards, Malini S |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting w/ a sumif | Excel Discussion (Misc queries) | |||
| function question (sumif countif conditional) | Excel Worksheet Functions | |||
| SUMIF + Conditional Formatting | Excel Discussion (Misc queries) | |||
| Conditional Formatting with IF function | Excel Worksheet Functions | |||
| Conditional Formatting "OR" function | Excel Worksheet Functions | |||
Linear Mode
