Unique count with a sumifs

[EmmaTM]

Hi,
I have a table of staff data and I am currently doing this sumifs calculation to pull over hours worked (column R) using departments and cost centres (columns K, Q & Y) there may be multiple lines for 1 worker:
=SUMIFS(Data!$R:$R,Data!$K:$K,'370'!$C$1,Data!$Q:$Q,'370'!O9,Data!$Y:$Y,'370'!C9)
In another cell I want to count within this data how many workers there are - I have a unique personnel code in column L

Thank you
Emma

 

[EmmaTM]

Hey - It resulted 1 in everything, so didn't give me what I was expecting