Thanks for your responses, apologize for lack of detail. Here is my problem below. Trying to determine my replacement cost for supplies already purchased. Problem in cross-referencing three inputs, pipe, zone and month? This is small example as I will have many more pipes, zones and months.
Have tried sumifs, dsum, arrays, nested formulas, etc. Can not get any to work, but I know it can work somehow.
This example is simplified, if the replacement values are different (which they will be) will just need to multiply volume times replacement cost for each month and then divide by total volume to arrive at weighted average replacement cost. Biggest challenge I need assistance with is cross-referencing two seperate tables with 3 sets of criteria.