J
JessB
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
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