Generate an Excel COUNTIF formula.

How to use it

Start with the same request, then adjust it to your sheet.

Use COUNTIF when you need to count how many rows match a condition in one range.

Step by step

• State what should be counted.
• Generate the COUNTIF formula.
• Adjust the range and threshold to match your sheet.

Useful variations

• If you need multiple criteria, ask for COUNTIFS instead.
• You can count text matches, blanks, or numeric thresholds.

Worked example

Example input and output

Expected output