If you want to sum all the E2 hours for QTR1 column, then try this:

=SUMIF(B2:B20,"E2",C2:C20)

assuming you have 20 rows of data. Copy across for the other quarters.

Is this what you meant?

Hope this helps.

Pete

On Jun 25, 9:46*am, Stuart wrote:
2009 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Title * * * *Grade * * * *QTR 1 *QTR 2 *QTR 3 * QTR 4
MAINTAINCE * *E2 * * * * 5000 * * * * 2500 * * * 1000 * * * * 500
DEISGN * * * * * PG1 * * * *2500 * * * *4000 * * * *3600 * * * * 1500
ESTIMATING * *E2 * * * * 1200 * * * * 1200 * * * *1000 * * * *1200

This is a example of how the table looks. am trying to see if possible that
a formula can look up the grade coloumn and select the approiate and then for
that grade add up all the total manhours ignoring the rest of the manhours