COUNTIF in the same sheet

ctsammon

I have two columns "Associate Name" which contains a list of names, and a corresponding list of birthdates "Date of Birth", both ever expanding. I would like to have a column that counts the number of times which that associate name and birthday appear in the sheet.

So if I enter "John Doe" and "1-1-24", the first time, the column will return "1". Later in the year, if I enter "John Doe" and "1-1-24" again in a different row, the column would show "2".

Is this possible within the same sheet?

Thanks in advance.

ctsammon

Think I got it to work 😁

=COUNTIFS([Associate Name]:[Associate Name], =[Associate Name]@row, [Date of Birth]:[Date of Birth], =[Date of Birth]@row)

ctsammon

Think I got it to work 😁

=COUNTIFS([Associate Name]:[Associate Name], =[Associate Name]@row, [Date of Birth]:[Date of Birth], =[Date of Birth]@row)