Count how many values are greater than the dataset's own average.
Copy this formula
=COUNTIF(A2:A100, ">"&AVERAGE(A2:A100))AVERAGE computes the mean, and COUNTIF counts cells above it — note the operator is joined to AVERAGE with &. It's a quick way to see how many items beat the typical value.
=COUNTIF(Sales, ">"&AVERAGE(Sales))→1818 reps beat the average.
COUNTIF needs the criterion as text. ">"&AVERAGE(...) builds ">62.5" dynamically.
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.