Track Job Applications by Status With COUNTIF

Excel & Google Sheets

How it works

COUNTIF scans the status column (D) and counts every cell that says Interview. Using the whole column D:D means new applications are counted the moment you add a row — no range to update. Repeat the formula with "Applied", "Offer", and "Rejected" to build a small dashboard above or beside the tracker, and each number updates itself as you change statuses. The match ignores case, so "interview" and "Interview" both count — but a different word or a stray space won't.

D:D

The whole Status column — new rows are included automatically.

"Interview"

The status to count. Swap in Applied, Offer, or Rejected for the other stages.

When to use it

Use this for any pipeline you track in rows: your own job search, candidates you're hiring, sales leads, or grant applications. A stage-count summary shows at a glance where things are stalling.

Common mistakes

• ✕Statuses typed inconsistently — "Interview", "interviewing", "Intv".

  ✓COUNTIF only counts exact matches, so variants vanish from your totals. Add a dropdown (data validation) on the Status column so every row uses the same labels.

• ✕Trailing spaces hiding matches.

  ✓"Interview " (with a space) is not "Interview". If a count looks low, check for stray spaces or use =COUNTIF(D:D,"Interview*") to catch them.

• ✕Putting the summary in the same column it counts.

  ✓If the summary cell containing the word "Interview" sits in column D, COUNTIF(D:D,...) counts it too. Keep summary formulas in a different column or a separate summary block.