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.

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.

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.

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.

Sir,

1. In E319= value is presently blank, but when purchase of goods I input Qty
of particular Item.
2. In A319 presentlyin it is blank and cell formula is =IF(B3190,A318+1,"")
3. In B column Transaction sheet is ID number same when Sales occured I
input Item ID No.
4. In C column of Transaction Item Quantity I input when Sales occured.

When E319 and A319 both are presently blank why it is not returning 0 value.
Although when I input value
in A319 and E319 it is working perfectly.

This formula is for Inventory Record. How many Items Inward and how many
items has outward. I have Two Sheets
first Inventory for Inward and Transactions for Sale.

Regards

Rao Ratan Singh

"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.

Sir,

1. In E319= value is presently blank, but when purchase of goods I input Qty
of particular Item.
2. In A319 presentlyin it is blank and cell formula is =IF(B3190,A318+1,"")
3. In B column Transaction sheet is ID number same when Sales occured I
input Item ID No.
4. In C column of Transaction Item Quantity I input when Sales occured.

When E319 and A319 both are presently blank why it is not returning 0 value.
Although when I input value
in A319 and E319 it is working perfectly.

This formula is for Inventory Record. How many Items Inward and how many
items has outward. I have Two Sheets
first Inventory for Inward and Transactions for Sale.

Regards

Rao Ratan Singh

Sir,

1. In E319= value is presently blank, but when purchase of goods I input Qty
of particular Item.
2. In A319 presentlyin it is blank and cell formula is =IF(B3190,A318+1,"")
3. In B column Transaction sheet is ID number same when Sales occured I
input Item ID No.
4. In C column of Transaction Item Quantity I input when Sales occured.

When E319 and A319 both are presently blank why it is not returning 0 value.
Although when I input value
in A319 and E319 it is working perfectly.

This formula is for Inventory Record. How many Items Inward and how many
items has outward. I have Two Sheets
first Inventory for Inward and Transactions for Sale.

Regards

Rao Ratan Singh

So you are looking for values in B corresponding to A319, which is blank;
how many cells in column B are zero or blank, and what is the sum of the
corresponding cells in column C?
--
David Biddulph

"Rao Ratan Singh" wrote in message
...
Sir,

1. In E319= value is presently blank, but when purchase of goods I input
Qty
of particular Item.
2. In A319 presentlyin it is blank and cell formula is
=IF(B3190,A318+1,"")
3. In B column Transaction sheet is ID number same when Sales occured I
input Item ID No.
4. In C column of Transaction Item Quantity I input when Sales occured.

When E319 and A319 both are presently blank why it is not returning 0
value.
Although when I input value
in A319 and E319 it is working perfectly.

This formula is for Inventory Record. How many Items Inward and how many
items has outward. I have Two Sheets
first Inventory for Inward and Transactions for Sale.

Regards

Rao Ratan Singh

"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.

In inventory Sheet in B to C cells 4 to 327 are filled with Data and from 328
to end it is still blank.

"David Biddulph" wrote:

So you are looking for values in B corresponding to A319, which is blank;
how many cells in column B are zero or blank, and what is the sum of the
corresponding cells in column C?
--
David Biddulph

"Rao Ratan Singh" wrote in message
...
Sir,

1. In E319= value is presently blank, but when purchase of goods I input
Qty
of particular Item.
2. In A319 presentlyin it is blank and cell formula is
=IF(B3190,A318+1,"")
3. In B column Transaction sheet is ID number same when Sales occured I
input Item ID No.
4. In C column of Transaction Item Quantity I input when Sales occured.

When E319 and A319 both are presently blank why it is not returning 0
value.
Although when I input value
in A319 and E319 it is working perfectly.

This formula is for Inventory Record. How many Items Inward and how many
items has outward. I have Two Sheets
first Inventory for Inward and Transactions for Sale.

Regards

Rao Ratan Singh

"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.