Countif needed help

[wiewie002]

Dear Friends,
I try to created a formula for counting number in a range of data.
but I have problem with data which used range. please find the attached file for details.
Thank you in advance for you help.

count need help.xlsx

Regards,
Wie

[protonLeah]

For instance:

Please Login or Register  to view this content.

[FlameRetired]

In D3

Please Login or Register  to view this content.

In D4

Please Login or Register  to view this content.

In D5

Please Login or Register  to view this content.

You already have D2.

[wiewie002]

Dear Ben and Dave,
Thanks a lot for your help. its great.

Regards,
Wie

[FlameRetired]

You're welcome. Glad to help. Thanks for the feedback and the rep.