Calculate With Criteria

[Kumara_faith]

Hi,


I have the following table which I need to summarize the data based on productivity data by staff ID , day and hours.

Example, for staff M1, the total data for "LM" for all Mondays in the month of March based on table 1 is summarized on table 2 in cell C23

Similalarly, total "Hours" worked for staff M1 for all Mondays in the month of March based on table 1 is summarized on cell D23 in table 2.

I am trying to use sumproduct formula to generate this data in table 2 based on table 1 but it does not work.

Appreciate help.