COUNTIF in the same sheet

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.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!