"Aladin Akyurek" wrote in message
...
Bob Phillips wrote:
=SUMPRODUCT((A1:A20=1)/COUNTIF(B1:B20,B1:B20&""))


Did you test that? Here is a sample:

Of course I did, and it worked with data as presented. I didn't test with
gaps in column B, but that is simply corrected if necessary.