calculating cells
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
|