Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Excel Macro-How do I write the formula so that if Column B=(persons name) then add 1.?
I have multiple people that give me work, that I keep track of. I’ve been wondering what the percentages are from each person. I’ve been keeping track of who gives me what work. What I need to know is how to write the formula so that if Column B=(persons name) then add 1. So that every time a persons name appears in the column you add 1 to the total from that person.
2 Answers
- Greg GLv 710 years ago
If you just keep entering the name down column B, for example:
B
Greg
Joe
Jim
Pat
Greg
What I would do is put a list of each name down another column somewhere, I'll use Column A for this example, then wherever you want your counts to be:
=COUNTIF($B:$B, A1)
Copy that formula as many times as needed. If you want to make it display the name beside the #:
=A1&": "&COUNTIF($B:$B, A1)
So if A1 has the name "Greg" in it, then your result will be either "2" or "Greg: 2", depending on which of those 2 formulas you choose to use.
