coba formula ini :

=COUNTIFS($A$2:$H$11,">="&(--LEFT(A14,(SEARCH(" -
",A14))-1)),$A$2:$H$11,"<="&(--RIGHT(A14,LEN(A14)-((SEARCH(" -
",A14))+2))))


Semoga membantu.
Salam.

Fano The Miner

On 3/12/12, hadiat Supriatna <[email protected]> wrote:
>
>
> Dear Para Suhu Excel,
>
> Mohon bantuan-nya ya, terimakasih.
>
>
> salam
> hadiat

Kirim email ke