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
-
Think I got it to work 😁
=COUNTIFS([Associate Name]:[Associate Name], =[Associate Name]@row, [Date of Birth]:[Date of Birth], =[Date of Birth]@row)
Answers
-
Think I got it to work 😁
=COUNTIFS([Associate Name]:[Associate Name], =[Associate Name]@row, [Date of Birth]:[Date of Birth], =[Date of Birth]@row)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!