| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting number and text values
Can someone help me with this? I am trying to count and add number of
occurrences (marked by 1 or zeros) for a specific client(using bl* to find all clients starting with bl name) I am using sum function =SUM(IF(D17:D410="bl*",IF(A17:A410="1",1,0))) but return value is always 0 I also tried =COUNT(IF((D17:D200="bl*")*(A17:A2000=1),A17:A2000 )) but result is also incorrect. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting number of times certain Text Values appear | Excel Discussion (Misc queries) | |||
| Counting Text as a Number | Excel Worksheet Functions | |||
| Counting a mixed text/number column based on text in another colum | Excel Discussion (Misc queries) | |||
| counting unique items(values or text) | Excel Worksheet Functions | |||
| Counting the number of values in a list between two specified valu | Excel Worksheet Functions | |||
Threaded Mode
