Need help for right excel formula

Please help me about finding the formula in excel spreadsheet.

ex.
Column A Column B Column C Column D Column E
Bianca Adriel 2 (Total # of person in the list)
Joseph Maricar Kakai 3 (Total # of person in the list)

It's like an auto sum

Thank you!
Nher

Hi, welcome to the forum

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(note: this change is not optional )