Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting specific formatted cells
Hallo,
I was just wondering if it is possible to add cells together which for instance are only coloured red. I mean, cells in the same colomn. Almost something like using the countif formula. I have highlighted quite a few cells (in one specific colomn) which I want to add. I want to know if there is an easier way of adding those cells together then to go and actually select those cells and put the + sign in. Any help would be greathly appreciated. Thank you. Tazzy |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting specific formatted cells
Hi
Take a look at Chip Pearson's site. He has some code that will do what you require. http://www.cpearson.com/excel/colors.htm -- Regards Roger Govier "Tazzy" wrote in message ... Hallo, I was just wondering if it is possible to add cells together which for instance are only coloured red. I mean, cells in the same colomn. Almost something like using the countif formula. I have highlighted quite a few cells (in one specific colomn) which I want to add. I want to know if there is an easier way of adding those cells together then to go and actually select those cells and put the + sign in. Any help would be greathly appreciated. Thank you. Tazzy |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting specific formatted cells
See http://xldynamic.com/source/xld.ColourCounter.html for a solution.
-- --- HTH Bob (change the xxxx to gmail if mailing direct) "Tazzy" wrote in message ... Hallo, I was just wondering if it is possible to add cells together which for instance are only coloured red. I mean, cells in the same colomn. Almost something like using the countif formula. I have highlighted quite a few cells (in one specific colomn) which I want to add. I want to know if there is an easier way of adding those cells together then to go and actually select those cells and put the + sign in. Any help would be greathly appreciated. Thank you. Tazzy |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting specific formatted cells
I dont really know what they are trying to say. I typed the formula and the
cell says #NAME? What does it mean?? "Bob Phillips" wrote: See http://xldynamic.com/source/xld.ColourCounter.html for a solution. -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Tazzy" wrote in message ... Hallo, I was just wondering if it is possible to add cells together which for instance are only coloured red. I mean, cells in the same colomn. Almost something like using the countif formula. I have highlighted quite a few cells (in one specific colomn) which I want to add. I want to know if there is an easier way of adding those cells together then to go and actually select those cells and put the + sign in. Any help would be greathly appreciated. Thank you. Tazzy |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting specific formatted cells
Read the whole articel and copy the code that you need as well as just the
formula. -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Tazzy" wrote in message ... I dont really know what they are trying to say. I typed the formula and the cell says #NAME? What does it mean?? "Bob Phillips" wrote: See http://xldynamic.com/source/xld.ColourCounter.html for a solution. -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Tazzy" wrote in message ... Hallo, I was just wondering if it is possible to add cells together which for instance are only coloured red. I mean, cells in the same colomn. Almost something like using the countif formula. I have highlighted quite a few cells (in one specific colomn) which I want to add. I want to know if there is an easier way of adding those cells together then to go and actually select those cells and put the + sign in. Any help would be greathly appreciated. Thank you. Tazzy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting cells based on conditional formatting | Excel Discussion (Misc queries) | |||
Counting blank cells until value is reached | Excel Worksheet Functions | |||
Counting cells not containing specific text | Excel Worksheet Functions | |||
Counting cells with a specific background colour | Excel Discussion (Misc queries) | |||
Formula for counting specific cells with value greater than 0 | Excel Discussion (Misc queries) |