formula





















 

 

 

 

DIVISION:

North South
SUBJECT: OfficeMgr Training Travel OnSite OfficeMgr Training Travel OnSite
                 
12/1/2017                
12/2/2017                
12/3/2017                
12/4/2017                
12/5/2017                
12/6/2017                
12/7/2017                


















First Workbook: John   North South
Dec-17 12/1/2017 Training 0.07 0
Dec-17 12/1/2017 OnSite 0.05 0
Dec-17 12/3/2017 OfficeMgr 0.08 0.02
Dec-17 12/4/2017 Travel 0.02 0.08
         
Second Workbook: Carmen   North South
Dec-17 12/1/2017 Training 1.00 0
Dec-17 12/3/2017 OfficeMgr 0.05 0.05
Dec-17 12/4/2017 Travel 0.05 0.05
Dec-17 12/7/2017 OnSite 0.60 0.04

Hi,

From two workbooks I would like a formula to sum the hours for each day by subject:

example: on Dec 1 total training for North is 1.07, 0 for South

 

 

     

 

 

 

By: Manjit

Leave a Reply

Your email address will not be published. Required fields are marked *