Skip to content

COUNTIFS with a number and a text condition

Count rows that pass several tests, such as orders over 500 that are marked Paid.

The formula

Argument separator
Excel and Google Sheets
=COUNTIFS(D2:D100, ">500", E2:E100, "Paid")

How it works

  1. D2:D100, ">500"

    Only count rows where the amount is greater than 500. Comparison operators go inside quotes.

  2. E2:E100, "Paid"

    And where the status is Paid.

Example

D: AmountE: Status
750Paid
900Open
520Paid
120Paid

Tips

  • Result for this data: 2.
  • To compare with a cell, join the operator and the cell: ">"&G1.