ContributionsMost RecentMost LikesSolutionsRe: Need to create a countif formula to count repeated values in table. Is this possible/how?Any help is appreciated. Thanks for your time!Re: Need to create a countif formula to count repeated values in table. Is this possible/how?Sample data below. Don't want a report per say, but want to see when I select Customer Number - 1 there's a field (countif formula) that shows the exact same value in [Customer Phone] occurs 4 times in this table (countif in excel). If it was possible for the value in my countif formula once I click it to bring me to a report with all matching numbers, would be ideal. Then I need to apply this logic/formula to many other fields. Customer Number Customer Name Customer Phone 1 John Smith 123-456-7890 2 Jane Does 123-456-7890 3 Gilbert Grape 123-456-7890 4 John Deere 321-456-7890 5 Darth Vader 123-456-7890Re: Need to create a countif formula to count repeated values in table. Is this possible/how?What info do you need from me/my app in order to do this via scripting? Would love to see how this could be done to solve the issue we're trying to solve.Re: Need to create a countif formula to count repeated values in table. Is this possible/how?I was hoping to apply this to multiple fields: Phone Number, Address, Email etc. to show me how many times I have different Customer Numbers (my key field, do not want to change). A countif gets me what I need in excel, but would have to operate out of a spreadsheet and do not want to do that. No solution for countif (within the same table) in Quick Base?Re: Need to create a countif formula to count repeated values in table. Is this possible/how?Doesn't a summary report by definition filter out duplicates, similar to a pivot table in excel? What I need are the values the summary report summarizes (e.g. John Smith appears on 12 records) to be reportable and dynamic to add new records meeting criteria. A field to say the value in the field X appears Y amount of times in the whole table. I can solve this by exporting the Summary Report to a new Table, but then I lose the ability for it to update automatically.Need to create a countif formula to count repeated values in table. Is this possible/how? Need to create a countif formula to count repeated values in table. Is this possible/how in Quick Base? Been messing with "Summaryfield options", but can't quite get what I'm after. Could do it in excel and import back in, but want value to update automatically as I add more records to my table.