Calculate Based On Multiple Criteria

Hi,

I have the attached spreadsheet with data on table 1.

In Table 2, I need a formula to summarize the number of task based on status on table 1 in percentage for each department.

Appreciate all the help.

Given that you have the matrix laid out, you can use:

D17: =SUMPRODUCT(--($C$4:$C$10=$C17),--($E$4:$E$10=D$16))

Copy down and across.

You might want to consider a Pivot Table as an alternative approach.


Regards, TMS

Hi

In D17, try this:

=SUMPRODUCT(($C$4:$C$10=C17)*($E$4:$E$10=D16))

Is this, what are you looking for?

You're welcome.

You are welcome!