Good morning all,

I am using the following array formuale in my worksheet to calculate the sum
of a column where one column is equal to a variable and another column is
equal to "CN". My formulae keeps giving me the NUM error. This error
appears even when I use the SUMPRODUCT function. Has anyone any ideas on how
to amend this???

{=SUM(IF((EmployeeData!A:A=B8)*(EmployeeData!L:L=" CN"),EmployeeData!K:K))}

Thanks,

Ciara