I got the following table in Excel (Microsoft Excel 2011 for Mac).

It is basically for controlling issues. It shows a number of persons (employees) that are assigned to specific work-packages that belong to one single project. Now I would like to get an overview about "planned" hours for a single project. The problem is, that it has two sums. First, the sum of work-packages that belong to the project. Second, the sum of persons that belong to the department. So it's a cross-sum over work-packages and departments.

Question: I made the second table just as an example (manually). But how to do this with Excel?

Remark: Each person has two columns. One contains the planned hours, the other one contains the currently spent hours. I could remove that second column if necessary. It's more important to sum the work-packages and departments.


  • Would a pivot table work for you? – Raystafarian Aug 17 '15 at 16:51
  • I would prefer a non-pivot table. – Matthias Aug 18 '15 at 9:57
  • I would suggest a macro then. – Raystafarian Aug 18 '15 at 11:08
  • I used sumproduct now – Matthias Aug 24 '15 at 14:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.