Any help would be greatly app
I have modified a template from MS Office/Mac for a employee work schedule
But I am having a hard time figuring out the Sum formula they used in the template to calculate total paid hrs for the week and employee
I had to update/add more shifts and more employees to the table so everything I added new does not add up like it should
Here is my updated worksheet:week(14-25).xlsx
Here was original template :schedtemp.xlsx
you have na errors in column k to q you can eliminate them by using iferror
=iferror(theformula,0)
or without altering those formulas
array entered -> ctrl+shift+enter
=SUM(IF(ISNUMBER(K7:Q7),K7:Q7))
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Thank you
I keep getting a value of 0 in hours column??
The formula is array entered -> not just enter.
Click the first formula then press F2 ->>now hold down ctrl key + shift key then hit Enter key you can then drag the formula down using the fill handle.
you'll notice the formula now that has curly braces if done right
it becomes.
{=SUM(IF(ISNUMBER(K7:Q7),K7:Q7))} with the curly braces
the braces are NOT to be manually typed.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks