Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
New problem
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
New problem
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
New problem
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
New problem
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
New problem
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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
New problem
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
New problem
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. |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
New problem
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. |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
New problem
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
problem with a conditional max problem | Excel Discussion (Misc queries) |