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