Sum amounts that meet several conditions

In G7, total amounts where region and status match G2:G3 and the date is at least G4 but before G5.

The answer cells begin blank. Enter a reusable formula and check it against the published practice datasets. Hints and the solution are available when you choose them.

Practice stays on this device. No worksheet data is uploaded.

A checkpoint records a fresh check of every dataset. This attempt tracks built-in hints, solutions, steps and worked examples; it does not establish independent authorship.

Help recorded: none of these built-in aids opened.

A LITTLE PRACTICE

Make the formula your own.

View task requirements

In G7, total amounts where region and status match G2:G3 and the date is at least G4 but before G5.

Runs in your browser

1	Date serial	Region	Status	Amount		Condition	Value
2	46296	East	Paid	120	—	Region	East
3	46297	East	Pending	80	—	Status	Paid
4	46300	West	Paid	200	—	Start (inclusive)	46296
5	46301	East	Paid	250	—	End (exclusive)	46327
6	46310	East	Paid	-30	—	—	—
7	46326	East	Paid	90	—	Matching total	—

No account. No upload. Just try it.

Read the full explanation →