Thank you, I’m going to play with these.
Background ….I built a quoting sheet for the estimators. In the main
spread sheet I used the formula
=Main!G3*SUMIF(I21,"T",H21) for the tax column.
Main!G3 is my tax rate
I21 is the column
I put the letter in of the product is taxable
And H21 is the pretax total for the product.
All works great.
In this spread sheet I had a section for mechanic and helper rates and
the hours quoted. I was asked by them of I could bring this
information into the main quoting spreadsheet. This is so they could
break down the labor required for a given product when required.
I was thinking since I use T to look up the Tax amount then there must
be a way I could use M to look up the mechanic rate and A to look up the
apprentice rate if one of these letters were selected.
So in essence the product quantity cell would become the mechanic or
apprentice hours if M or A was chosen. If nether was chosen it would
just use the standard calculations I gather that’s where the SUMIF
comes in.
--
Xenos
------------------------------------------------------------------------
Xenos's Profile:
http://www.excelforum.com/member.php...o&userid=26526
View this thread:
http://www.excelforum.com/showthread...hreadid=470527