I am using the following Array Formula. It works perfectly as is but if I insert the Range Names LNames and Lfrom instead of a cell range reference I get an error. Any suggestions please.

{=SUM(IF(YEAR($B$1:$B$53)=LeaveYear,IF($I3=$A$1:$A $53,LTaken,0),0))}

LeaveYear =Data!$AC$1
Lfrom =OFFSET(Data!$B$1,0,0,COUNTA(Data!$B:$B),1)
LNames =OFFSET(Data!$A$1,0,0,COUNTA(Data!$A:$A),1)
LTaken =OFFSET(Data!$D$1,0,0,COUNT(Data!$D:$D),1)

Solved it.

{=SUM(IF(YEAR(Lfrom)=LeaveYear,IF(LNames=I3,LTaken ,0),0))}