u/Andrey_Smith0

I’m trying to count how many values in a range meet a condition, but I can’t seem to get the formula right.

I’ve got a column of numbers (sales amounts), and I only want to count how many are above a certain threshold (like over 1,000).

I tried something like this:

=COUNTIF(C2:C150, >1000)

but Excel throws an error, so I’m guessing I’m missing something basic with the syntax.

I’m still pretty new to using formulas, so not sure if this is just formatting or if I’m using the wrong function entirely.

Running Excel 2013 if that matters.

What’s the correct way to do this?