| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to make excel simply count red x's?
I just need excel to simply count the red x's in my document. It will
simplify all kinds of work. I have tried: =SUMPRODUCT(--(ColorIndex(A1:A100,TRUE)=3)) , but i keep getting a name error. When i change SUMPRODUCT to COUNT i dont get the name error but it shows 0. Are there any simple solutions to this? I dont have the time to get into visual basic either. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I simply output Deciles in Excel? | Excel Discussion (Misc queries) | |||
| How do I make an X appear in a cell by simply double clicking it? | Excel Discussion (Misc queries) | |||
| how to get excel to simply count the number of red x's | Excel Discussion (Misc queries) | |||
| is there a way to make dates simply be read as text? | Excel Programming | |||
| Excel 2003 Simply Stopped Working | Excel Worksheet Functions | |||
Threaded Mode
