Sumifs forumula question here. For work allocation, each week team members report on the name of their project and the approximate percentage of time it will take. For example, Project A = 50% and Project B = 20%. I'm trying to sum the total of the projects. The first criteria is the status of the project; I want to count only "in progress" precentages. The second criteria is by contact. Since the sheet displays multiple team members, i want a cell to count only the percentages for that team member.
Two questions: first, i have been able to get the formula to work, but i didn't save it properly, and now i can't get back to that original formula. Second, usually when I do this kind of thing, I figure out the formula for the first team member, and then copy and paste the formula for all of the remaining team members, and simply change the contact name. However, on this sheet when i do that, when i make the copy, the original one then shows "unparseable"
Final note* this sheet is for a colleague in London so the word spelling for the word "utilisation" is different than it is spelled in the US. That's not the error.
Help Article Resources
Check out the Formula Handbook template!