Name Values

Closed
brendanconlin Posts 1 Registration date Monday 14 November 2016 Status Member Last seen 14 November 2016 - 14 Nov 2016 à 22:35
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 15 Nov 2016 à 11:31
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 12 September 2010 Status Contributor Last seen 27 December 2022 555
15 Nov 2016 à 11:31
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