Formuladrill

Level 2: Logic and counting Exercise 38 of 118

Everything except one status

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

Add up every order amount except the orders whose status is the one in F1. Put the total in F2, and refer to F1 rather than typing the status.

What this exercise teaches

The <> operator works inside SUMIF, COUNTIF and the IFS versions the same way > and < do: as text joined to the cell with &. Taking the unwanted status off the grand total gives the same number.

A hint if you get stuck

The criteria "<>"&F1 means not equal to the value in F1.

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