Count numbers greater than or less than a number

You can use the COUNTIF function and operator to create a formula that counts the numbers in a list that are greater than or less than another number.

  1. Select the cell where you want to display the count results. This is where the formula will be entered.

  2. On the Formulas tab, under Function, click Formula Builder.

    Fanen Formler, gruppen Funktioner

  3. In the Formula Builder, double-click COUNTIF.

  4. Under Arguments, click the box next to range, and then enter the range of cells you want to examine.

  5. Under Arguments, click the box next to criteria, and then type the greater-than symbol (>) or less-than symbol (<), and the value you want to search above or below.

  6. Press RETURN .

    The result appears in the cell where you entered the formula.

View an example

You have been tracking inventory in the sheet below. Use the formula in the following table to summarize your inventory transactions.

Transaction

Date

Location

Item

Quantity

201000

5/1

California

tent

2

201001

5/4

Washington

headlamp

2

201002

5/5

Washington

sleeping bag

-1

201003

5/5

Washington

headlamp

1

201004

5/6

California

tent

-3

201005

5/13

Oregon

backpack

-1

201006

5/16

Oregon

backpack

-1

201007

5/19

California

car rack

2

201008

5/21

California

backpack

1

201009

5/28

California

car rack

1

Formula

Description (Result)

=COUNTIF(E2:E11,<0)

The number of transactions where an item left the warehouse (4).

See also

Calculation operators and order of operations

Ways to count cells in a range of data

Count how often a value occurs

Count unique values among duplicates

Del Facebook Facebook Twitter Twitter Mail Mail

Var disse oplysninger nyttige?

Fantastisk! Har du mere feedback?

Hvordan kan vi forbedre det?

Tak for din feedback!

×