how to sum when two conditions are met, e.g. name and task number
I have a spreadsheet in which I am keeping track of employee's hours worked
on individual tasks, so I need to sum cells by person and by task. can't
figure out how to say sum if "name" and "task #". Thanks for any help!
|