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.
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 exerciseMore exercises in Logic and counting
- Pass or fail
- Letter grades
- Bonus for the north
- Count the shipped orders
- Sales for one region
- Two conditions at once
- Flag for review
- Count with two conditions
- Average for one region
- Scores above a bar
- Best sale in a region
- Shipping tiers
- No more #DIV/0!
- Rank with ties
- Count with a wildcard
- Discount rules
- Average with two conditions
- Sales between two dates
- Plan codes to prices
- Revenue for one region, no helper column
- How many different customers
- One region or the other
- Name a step with LET