J jrl1208 Member Jan 20, 2016 #1 Hi I would like to know what formula I can use to pick up the total WE hours. Please refer to attached spreadsheet Thanks Attachments Dummy Wage.xlsx 19.2 KB · Views: 9
Hi I would like to know what formula I can use to pick up the total WE hours. Please refer to attached spreadsheet Thanks
Chihiro Excel Ninja Jan 20, 2016 #2 Something like this: =SUMIFS($AF$4:$AF$193,$H$4:$H$193,"<="&A14,$H$4:$H$193,">="&A14-6)
