I have the following spreadsheet. Basically Sam and Heather split out their assignment by task. When the task is complete, they mark it with
Y in the
Task Done column.
At the bottom, in yellow, I want to calculate the percentage of tasks done separately by Sam and Heather, based on the amount of tasks assigned to them and whether or not they marked it with a
Y. I tried
SUMIF function, but I think I am barking up the wrong tree.
Is it possible to do what I want using Excel? If so, how?