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?????? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to get excel to simply count the number of red x's
You need to install a UDF (which is VBA Visual Basic for Applications) or
wait until Excel 2007 comes out http://www.cpearson.com/excel/colors.htm on how to install it http://www.mvps.org/dmcritchie/excel/install.htm after you have installed it you can use the sumproduct formula -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com (Remove ^^ from email) wrote in message ups.com... 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?????? |
Reply |
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) |