How do I calculate hours in a given week for a specific task for a specific person
I have a sheet with the following columns:
-[Date] Type: Date
-[Name] Type: Contact List
-[Professional Development Time] Type: Text/Number (# of hours the person spent on professional development)
-[Project Related Time] Type: Text/Number (# of hours the person spent on projects)
Now I want to create a chart that calculates per week, the total # of hours, each contact has put towards each of these items.
Here's a visual
I'd imagine it would be using the sumifs formula but I haven't been able to figure out the syntax and how to do it.
Can anyone help?
Thanks in advance,
Help Article Resources
Check out the Formula Handbook template!