Conditional Logic

Excel formula for Count how many times a value repeats

Show how many times each value appears in a column.

Copy this formula

=COUNTIF(A:A, A2)

How the formula works

COUNTIF compares the cell against the whole column and returns its frequency. Pair it with the duplicate flag to both detect and quantify repeats.

=COUNTIF(A:A, A2)→3

This value appears three times.

How do I count repeats across two columns?

Use COUNTIFS with both columns as criteria pairs.

Need a formula for your own data?

Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.