| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count using Coloured Cells
Hi
I have followed the threads for this and still getting an error "NAME? Using Excel 2007. I have cells in B1:B17 with numerous colours. A1 to A7 I have a list referencing the colour I would like counted. The formula is in Col D. This is the code I am using. =SUMPRODUCT(--(ColorIndex(B1:B16)=ColorIndex(A6))) Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there an Excel forumla to count different coloured cells? | Excel Discussion (Misc queries) | |||
| XL2003: Count formatted cells (not coloured)... | Excel Worksheet Functions | |||
| Count coloured cells in range | Excel Worksheet Functions | |||
| Count coloured cells in a range | Excel Worksheet Functions | |||
| count coloured cells | Excel Worksheet Functions | |||
Threaded Mode
