I have attached below, the sample of the data i am working with. 2 columns, 2
rows. Considering this data to be on the same excel sheet, which formula can
i use to calculate the sum of hours for both weeks, for each employee. Im not
sure which formula to use.


Week 1

EMPLOYEE NAME NO.OF HOURS

ABC 40

XYZ 40


Week 2

EMPLOYEE NAME NO.OF HOURS

ABC 40

XYZ 40

Results should be on the same sheet as follows:

EMPLOYEE NAME NO.OF HOURS

ABC 80
XYZ 80