I am working on a formula for a matrix pricing...
I set up a sheet to make quick estimates with a labor time (then calculates a cost) parts and adds Tax. Keeps the errors down from using a calculator.
I currently have the matrix charts set up as
Grid price 1.png
With this at the bottom to calculate
Grid price 2.png
On paper you can follow each and get the total. but I want to use the Estimate sheet to add taxes and such in for a total.
I want to be able to put say 2.1 in B4 on Est sheet and get the total from the Grid (D11) of $233.10. That I can do but i want to put is any variation of B9-B24 and C8-L8 and get the corresponding total
here is what the Estimate sheet looks like.
Grid price 3.png
I have tried many different combinations with not any good results. Thanks in advance for any help.
Jared
Bookmarks