COUNTIF with the limit in a cell

Premium

In E2, count the products in B2:B7 with stock below the reorder level in E1. Join "<" and E1 with &, so the count follows when E1 changes.

E2
ABCDEF
1Product Stock Reorder level 40
2Pens 35 To reorder
3Paper 120
4Ink 12
5Folders 48
6Staplers 9
7Tape 60
8

Premium lesson

Unlock COUNTIF and every other lesson

This is a premium lesson. Premium lets you solve it and every other lesson, take the timed mock tests, and earn certificates you can share on LinkedIn.

Next with premium:SUMIFAVERAGEIF and AVERAGEIFS

It comes up in this mock test: Excel test (SHL format)

Your first month for $9.50 $19

50% off your first month when you join today.

Get your first month for $9.50

Then $19/month. Cancel any time, and get a full refund within 14 days if it isn't for you.

Already premium? Sign in
Need help?