hi,
your post is a tad vaque but i would suggest you look into the SUMIF function.
It will serach a range for critera such as "RTEG" and return values
associated with the criteria.
if sumif isn't what you need, post back with more details.

Regards
FSt1

"Cook" wrote:


Ok... I am creating a sheet that is going to help with billing. The
problem is that for the same job we have to bill to two different "unit
codes". So I have a table that has the "job operation" the associated
"bill amount" and the associated "unit code". Can I use this table to
sum up all "RTENG" codes in cell G13 and all "EMISC" codes in cell G14?

Does that makes sense?

Thanks

Cook


--
Cook
------------------------------------------------------------------------
Cook's Profile: http://www.thecodecage.com/forumz/member.php?userid=107
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=55941