Index Match With Multiple Criteria and Count Unique Value

[asolopreneur]

Here is my Google Sheet, you can show your magic here.

It would be great if you explain how your formulas works in layman's terms.

Thanks!

 

[Chrisdontm]

On the dashboard page;

In cell: C3
try this formula: =COUNTUNIQUE('Employee Data'!$A:$A)-1

In cell: J6
Try this formula: =SUMIFS('Employee Data'!$F:$F,'Employee Data'!$A:$A,$G6,'Employee Data'!$C:$C,J$4)

Then copy J6 over to the right,
and then copy row 6 formulas down...

 

[asolopreneur]

Thanks @Chrisdontm

The formulas are easy to use. I didn't know about countunique formula and sumifs to index.

I tried filter instead of sumifs and it's working.