Add Range If Q

[Seanie]

How would I add up the total in Columns B:E if a certain value is in
Col A

My idea was =SUMPRODUCT(('Sheet1'!$A$27:$A$65536=XYZ)*('Sheet1'!$B
$27:$E$65536))

But above doesn't give the answer I expect

 

[Seanie]

I see my error $27 should have read $2, so I must rows 2:26