Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to get excel to simply count the number of red x's
Thats all i have no clue. Is there a simple formula to do this, and why
am i seeing stuff about visualbasic to accomplish this? If there is no almost one line formula, what software can i use for this task? I've tried this : =SUMPRODUCT(--(ColorIndex( A3:A167,TRUE)=3)) i keep gettin a name error and when i change SUMPRODUCT to COUNT, i just get 0. But no name errors either. Any suggestions?????? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to count the number of Excel cells with text formatted Italic | Excel Worksheet Functions | |||
The number in this cell is formatted as text or preceded by an apostrophe" problem in Excel | Excel Discussion (Misc queries) | |||
convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
How do I count the number of cells in a column in excel that begi. | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) |