=SUM(IFERROW(--sheet1A2:D2,0))

This the formula that i got from one of the users but for some reason this formula works on sone cells wheb i drag it down.. any idea why and how to fix it?