Are the values of E319 and A319 changing as a result of you adding data? Do
want these to be fixed (absolute) or relative references?

"Rao Ratan Singh" wrote:

I m using this function
=E319+SUMIF(Transactions!B:B,A319,Transactions!C:C )*-1. Before 2 days ago it
was working good and returning 0 value. But presently. It is returning
-132057. This retrun value is changing after new entry made in my Inventory
sheet.

Why it is happeing.