without more detail, maybe
=vlookup("joe",sheet1!a2:x200,2,0)+vlookup("joe",s heet2!a2:x200,2,0)+

--
Don Guillett
SalesAid Software

"deliliah" wrote in message
...
hi
i am having trouble with getting a formula to work for a cumulative grade,
that will pull from different worksheets in the same workbook , any
suggestion?
thanks deliliah