Formuladrill

Level 2: Logic and counting Exercise 37 of 118

One region or the other

An Excel formula exercise from Formuladrill. Solve it with a formula bar on a live sheet in your browser, and it is checked the moment you submit.

The task

Put the combined sales of the two regions named in F1 and F2 into F3. A row counts when its region is one OR the other.

What this exercise teaches

Conditions inside one SUMIFS must all be true at the same time, so two values for the same column always return 0. OR logic means one SUMIF per value, added up.

A hint if you get stuck

SUMIFS joins its conditions with AND, and no row is in two regions at once. Add two SUMIF results together instead.

Functions used: SUMIF

Try it now, free, no account needed

Your first 15 exercises on Formuladrill are free. Open it on the practice page, solve it, and get instant feedback with a hint. A free account adds the worked solution; Pro unlocks every exercise, timed mode and the certificate.

Open this exercise

More exercises in Logic and counting