Formula to pull multiple variables for pricing...

Hi guys.

I'm attempting to consolidate and reference some data that we use to determine how much to quote a customer for a specific type of job. The job is coating stairs with one of two products, rubber or polyaspartic.

The data variables that influence pricing are in column A, with drop downs in B to select variable.

My aim is to be able to reference data (currently incomplete) from a separate page and weigh all six variable to provide accurate pricing...

Would anybody be able to point me in the right direction to get started, please? I don't mind doing my own homework, I'm not very proficient in Excel but I'm not lazy either.

Thanks,
Kevin.

Good afternoon Kevin,

I believe you may be having difficulties pulling the price based on all of the criteria above because of how the data is formatted. I have attached a workbook with one of example of how you may want to organize your data.

I used the concatenate function on "sheet 4" to keep the sumifs function on "sheet 1" simple.

I was not sure how the number of treads/use of existing stairs would modify the price, so these have been left out of the calculation. If the relationship between price/number of stairs is a constant %, it should be fairly easy to add into the sumif on "sheet 1."

A thousand thank you's guys. The idea to have my data in one solid lump, for whatever reason, didn't seem feasible to me. Clearly it's the way it has to be. The # of stairs is a direct multiplier of the final cost and I've been able to edit that already. The supply/existing variable is dependent on yet TBD pricing from our supplier, but will also be a simple matter of adding the cost of the steps to the cost of the coating.

Again, thank you very much. Your expertise is appreciated in that it definitely saved me a lot of time and energy.

Kevin.