multiple look up arrays to sum column based on various criteria

[deanusa]

Started a new thread as my explanation was off in the last thread

I have attached a workbook. I believe row 6 of the main tab perfectly illustrates the issue I have.

I am looking for one formula to have a total of 1981, however with the formula I have (SUMIFS) needs multiple formulas

If column A ends with temporaries or overlays, It would need to reference every option in column E: background tab, if column A ends with Other, it would need to source all possibilities from column F background tab, else its a standard DVD therefore would be based on the range in column D background.

Thanks again to everyone helping with this, it has been driving me crazy for days.

[Glenn Kennedy]

Please DO NOT create duplicate threads. This only WASTES TIME and causes confusion. Amend your original thread.

MODS - Please CLOSE this thread.


This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.