| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
counting coloured cells
I saw this formula on the message board,
=SUMPRODUCT(--(Colorindex(A1:A50 TRUE)=3)) It is suppose to count the cells that have RED Fonts in them. This is what I want to try and do. But I get an @name error. It does not like the Command COLORINDEX. This Function is not in the Paste Function menu. Where dos it come from. HELP Thanks Tony |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
| counting cells with conditional formatting applied | Excel Discussion (Misc queries) | |||
| counting text cells | Excel Worksheet Functions | |||
| Pivot table, how do you exclude counting cells with formulas as a | Excel Worksheet Functions | |||
Threaded Mode
