#VALUE! error

I have been trying to add up (from E4 to AV4) them. However there are blank cells which I tried- TO GO special and select blank- Type 0 and Click Ctrl+Enter. But it changes only Rows and columns that...