Clairvoyance is a requisite for answering people's questions about XL!

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"David Biddulph" wrote:

To answer that might stretch the clairvoyant powers of the group, so you may
need to help by looking at the data (and presumably by comparing it with the
data in a copy of the workbook from when it gave the results you expected).
Firstly what value do you have in E319?
Secondly what value do you have in A319, and how often does that value
appear in column B of your Transactions sheet? Then what values appear in
column C of your Transactions sheet in the rows where column B shows your
A319 value?
As a matter of idle curiosity, why do you have E319+SUMIF(...)*-1, rather
than E319-SUMIF(...)?
--
David Biddulph

"Rao Ratan Singh" wrote in message
...
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.