Name Values [Closed]

Report
Posts
1
Registration date
Monday November 14, 2016
Status
Member
Last seen
November 14, 2016
-
Posts
2697
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
February 23, 2021
-
Hi

I have a sheet of people's names in C8 : C59 and D8 : D59. I would like a formula that can check these ranges and if it sees a specific name it adds +1 to another cell, yet to be determined.

Any help would be most grateful.

1 reply

Posts
2697
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
February 23, 2021
457
Hi Brendanconlin,

Not enterily sure what you mean, but if you are looking for a way to count a specific name within the given range, then try this:
=COUNTIF(C8:D59,"Specific Name")

Best regards,
Trowa
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!