| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please help me with a Conditional Count...
Frustrated Newbie...
What is wrong with the following formula I've created, if I'm trying to count the number of occurrences in Column B that have 1's next to them AND have either a "*" or a "Fw:*" in Column At? A B FYI 1 FYI 1 FYI FW: FYI 1 Hi 1 FW: Hi 1 Formula: =SUMPRODUCT((A1:A6="*")*(A1:A6="Fw*")*(B1:B6=1) ) I would expect to get back a value of 3. I'm getting 0 and no errors. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional function with count | Excel Worksheet Functions | |||
| Conditional Count 2 Columns | Excel Worksheet Functions | |||
| Conditional Count | Excel Worksheet Functions | |||
| conditional count | Excel Worksheet Functions | |||
| Count IF and Conditional Formating | Excel Discussion (Misc queries) | |||
Threaded Mode
