Final Friday Fix: March Challenge 2018

It’s that time again, the long weekend! That should give you plenty of time to solve our Final Friday Fix. Devotedly brought to you by our team at SumProduct!

This month’s challenge is straightforward. Below is a table:

Notice the blanks?  Yes, that is part of the problem this month.  The challenge this month – can you set up a single formula to sum the sales amounts based on the values in the Business Unit and Quarter columns?  Note that your formula has to be capable of reading the blank values as a criterion.

For instance, your formula should return with a total of 50 when we enter B in the Business Unit and a blank value in Quarter.

Up for the challenge? Download the example file here to get started.

The solution will be posted on Monday so stay tuned ‘til then!