Count if with sum, sign, frequency.

Hi to all

i have a problem like this.

Open 3000354120
open 3000354123
closed 3000354121
open 3000354123
closed 3000354122
open 3000354123
closed 3000354124
open 3000354121
closed 3000354126
open 3000354127

and i want countif only open and numbers and not count duplicates " with using sum(sign(frequency(b1:b11,b1:b11))) "

i know how to not count duplicates with using =sum(sign(frequency(b1:b11,b1:b11)))

i hope u all understand...

I am attaching excel file for your reference...


Thanks in advance...

Mjr