according to the search, you can see his number.

according to your form, it should be like this:

B1 input =COUNT(FIND ("Changsha", A1:A4)) press c

trl+shift+enter to end

C1 input =COUNT(FIND ("Yiyang", A1:A4)) press C

TRL+Enter. A1:A4)) Press c

trl+shift+enter to end

It is suggested that you write the form in the following format:

Region name Changsha Yiyang Changde

Hunan Changsha = Count (Find (B1, A2: A5)) = Co

UNT (Find (C1, A2: A5)) =