Name Values

Closed
brendanconlin Posts 1 Registration date Monday November 14, 2016 Status Member Last seen November 14, 2016 - Nov 14, 2016 at 10:35 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 15, 2016 at 11:31 AM
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 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Nov 15, 2016 at 11:31 AM
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