The template in of 2 sheets where Sheet 2 reflects data manually inserted in Sheet 1.

Eg: Cell A1 in Sheet 2 has the formula =IF('Sheet1'!A1="","",'Sheet1'!A1),

Cell B1 in Sheet 2 has the formula =IF('Sheet1'!B1="","",'Sheet1'!B1) and so on.

Now the data from Sheet 1 fills 145 rows till column AB in Sheet 2.

In column AC in Sheet 2, I have a SUMIF formula that calculates the values row wise in Sheet 2 itself.

The issue I face is that the SUMIF formula in AC is reading the blank cells in Sheet 2 as 0 and hence the output is inaccurate.

Currently I am having to copy paste as values (removing the formulas) the data in Sheet 2 and then insert the SUMIF formula in column AC. This actually beats the purpose of a template with linked sheets.

Please help me with a way around this. Thanks in advance.