View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stuart Stuart is offline
external usenet poster
 
Posts: 62
Default 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