SUMIFS that leaves one value out

Premium

In F1, total the North orders that were not returned. Give SUMIFS two conditions: the region "North" and the status "<>Returned".

F1
ABCDEFG
1Region Status Amount North, not returned
2North Delivered 640
3South Delivered 310
4North Returned 220
5North Shipped 480
6West Returned 150
7North Delivered 390
8South Shipped 270
9North Returned 110
10

Premium lesson

Unlock SUMIFS 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:COUNTIFSVLOOKUP

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?