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.
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")