Count Repeated Values

Options

AndreMenezes

AndreMenezes ✭✭

11/17/22 in Formulas and Functions

Hey Team,

Please, how could I count repeated values in a column? I have a grid with a column called a quarter, and I would like to count how many times Q1, Q2, Q3, and Q4 appear.

Thanks in advance,

Andre Menezes

Screen Shot 2022-11-17 at 13.09.11.png

0 ·

Answers

Paul Newcome Community Champion

11/18/22

You would use a COUNTIFS.
=COUNTIFS(range, criteria)

CERTIFIED SMARTSHEET PLATINUM PARTNER
10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)
Training opportunities with my team and I
0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Count if box is checked in one column and there is a specific month year in the Month Year Column
Month Year column is a text/number format. There is a space between Month and Year in the column title and a space between month and year in the column cells, ex: 07 2025 I have tried a number of formulas and am not finding one that yields the count. Here is the most recent one I tried: =COUNTIFS([Month Year], "07 2025",…
Net Days showing 36500 no matter the actual dates provided.
I am trying to use the NETDAYS function, but it will only respond with 36500. The result should be like 60. The dates I am trying to count are part of some simple (COLUMN + COLUMN) formula.
Trying to return 3 months prior to Date Column
Hello, I am trying to make a column to return dates 3 month before the date in another column. Essentially going to be notifying teams 3 months before something expires. I have a column for the dates. It is set to "date" and i'm using this formula in a helper column =DATE(YEAR(DATE@row ), MONTH(DATE@row ) - 3, DAY(DATE@row…