I've spent about 4 hours now combing various resources to try to figure this out and nothing I've tried has worked yet (or the explanations have been so esoteric that I simply can't grasp them).

My problem is this:

I have a table with 12 columns, one for each month. Each month will have a quantity value. Based on the following tiered pricing table, I need to calculate the total (qty * price for each tier) for each month.

Pricing tiers:
2015-04-07_12-50-48.jpeg

The key here is that I want to be able to show the calculated total for each tier (for each month). Here's an example of what I'm trying to fill out (I manually calculated the first column just for an example):

2015-04-07_12-55-54.jpeg

I started down a nested IF route, but that became unwieldy very quickly. Then I tinkered with VLOOKUP and ran into a dead end. I've been trying to get my head around SUMPRODUCT, but I can't seem to get anything to work properly.

Any advice would be GREATLY appreciated. I would assume that this is SO COMMON yet, I cannot find good examples. And yes, I have read through http://mcgimpsey.com/excel/variablerate.html and it just didn't help me. I'm a visual guy and need an example that is specific to my need to be able to figure it out, unfortunately.

Thanks!