Hello MacRumors members,
I am working with Numbers on making a planning for my internship. I am having some trouble setting up the formula.
I am using 2 sheets. The first sheet basically exists of 'task' and 'spent hours'.
I would like to calculate the spent hours from the second sheet, where I register all the hours I worked on what task.
This means I need a formula that basically does:
sum(hours where(task-sheet2=task-sheet1))
I am getting stuck on the where part. I can get all hours to sum, but I need them to only count the hours that are specific to that task.
Any help would be appreciated.
I am working with Numbers on making a planning for my internship. I am having some trouble setting up the formula.
I am using 2 sheets. The first sheet basically exists of 'task' and 'spent hours'.
I would like to calculate the spent hours from the second sheet, where I register all the hours I worked on what task.
This means I need a formula that basically does:
sum(hours where(task-sheet2=task-sheet1))
I am getting stuck on the where part. I can get all hours to sum, but I need them to only count the hours that are specific to that task.
Any help would be appreciated.