Thank you for the feedback.
It made my day.
Bill K
"gracious" wrote in
message ...

Gracious...
Your percentages do not add up to 100
You need to divide each individual job cost into the sum of the
job costs not into the invoice total.i.e. 171.61 into 280.83 to get
61.1085%
etc.
--
Greetings from New Zealand
Bill K

Thank you so very much! I guess I had looked at it too long and got
frustrated and didn't realize that I was adding in the H/C to
calculate the %....whew...what a relief thank you for setting me
straight and all the way from New Zealand!!! :) TY Bill K HUGS HUGS
HUGS ;)


--
gracious
------------------------------------------------------------------------
gracious's Profile:
http://www.excelforum.com/member.php...o&userid=23166
View this thread: http://www.excelforum.com/showthread...hreadid=382922