| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
multiple line two accumulators
I'm able to get a two cell accumlator going but my problem is I have multiple
lines that I need this for. Ex: A1(amt entered) F2(accum. total), which goes from A1 & F2 thru A500 & F500 These totals are for each line/part number for whats being shipped out, with keeping overal total for what has been shipped for that part. I've been looking at different codes but havent found the information needed to make this happen. Hopefully it can but please advise with any assistance. Thanks!!!! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
multiple line two accumulators
If I understand correctly, you want the value in column F to indicate the
accumulated total (running total) of the amounts in column A for a particular part number (which is in another, unspecified column? I will have to use that column, so I will arbitrarily make it column C). You could use a worksheet formula such as this in your F column - it is written for F2; could be copied down in column F to work for the rest of the range - but only if you follow the relative/absolute references carefully: F2 = SUMIF($C$1:$C2,$C2,$A$1$A2) "EED" wrote: I'm able to get a two cell accumlator going but my problem is I have multiple lines that I need this for. Ex: A1(amt entered) F2(accum. total), which goes from A1 & F2 thru A500 & F500 These totals are for each line/part number for whats being shipped out, with keeping overal total for what has been shipped for that part. I've been looking at different codes but havent found the information needed to make this happen. Hopefully it can but please advise with any assistance. Thanks!!!! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
multiple line two accumulators
Let me rephrase....
This is for incoming parts that we're dealing with. No duplicate part numbers either and its too keep track of total amt of parts shipped for THAT line. Which there could be up to 500 diff lines but needs only keep accumulative total per part/line. I can get an accumulator working for one line but I need this to work for all lines if need be. Ultimately the amt entered in E1 should accumulate to F1 - as E2/D2, E3/D3. Again this is only for each line/part number, not an overall total for certain parts or all parts. I hope this is more clear on what I need. the spreadsheet goes.... A B C D E F Date - Part number - Job number - Quantity - Quantity Shipped - Total Shipped today 1 XXX XXXX XXXX 5000 2000 3000 2 XXX XXXX XXXX 2500 1500 2000 3 4 Thanks! "K Dales" wrote: If I understand correctly, you want the value in column F to indicate the accumulated total (running total) of the amounts in column A for a particular part number (which is in another, unspecified column? I will have to use that column, so I will arbitrarily make it column C). You could use a worksheet formula such as this in your F column - it is written for F2; could be copied down in column F to work for the rest of the range - but only if you follow the relative/absolute references carefully: F2 = SUMIF($C$1:$C2,$C2,$A$1$A2) "EED" wrote: I'm able to get a two cell accumlator going but my problem is I have multiple lines that I need this for. Ex: A1(amt entered) F2(accum. total), which goes from A1 & F2 thru A500 & F500 These totals are for each line/part number for whats being shipped out, with keeping overal total for what has been shipped for that part. I've been looking at different codes but havent found the information needed to make this happen. Hopefully it can but please advise with any assistance. Thanks!!!! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
multiple line two accumulators
I still don't quite get it: Are you trying to calculate the amount in "Total
Shipped" (column F), or something else? How are you defining "accumulated total?" - accumulated for what? If there is no duplication in parts why is the total not simply Quantity - Quantity shipped (e.g. F2=D2-E2)? How did you get 2000 as the total shipped in your second line? I am either misunderstanding the problem or the math. "EED" wrote: Let me rephrase.... This is for incoming parts that we're dealing with. No duplicate part numbers either and its too keep track of total amt of parts shipped for THAT line. Which there could be up to 500 diff lines but needs only keep accumulative total per part/line. I can get an accumulator working for one line but I need this to work for all lines if need be. Ultimately the amt entered in E1 should accumulate to F1 - as E2/D2, E3/D3. Again this is only for each line/part number, not an overall total for certain parts or all parts. I hope this is more clear on what I need. the spreadsheet goes.... A B C D E F Date - Part number - Job number - Quantity - Quantity Shipped - Total Shipped today 1 XXX XXXX XXXX 5000 2000 3000 2 XXX XXXX XXXX 2500 1500 2000 3 4 Thanks! "K Dales" wrote: If I understand correctly, you want the value in column F to indicate the accumulated total (running total) of the amounts in column A for a particular part number (which is in another, unspecified column? I will have to use that column, so I will arbitrarily make it column C). You could use a worksheet formula such as this in your F column - it is written for F2; could be copied down in column F to work for the rest of the range - but only if you follow the relative/absolute references carefully: F2 = SUMIF($C$1:$C2,$C2,$A$1$A2) "EED" wrote: I'm able to get a two cell accumlator going but my problem is I have multiple lines that I need this for. Ex: A1(amt entered) F2(accum. total), which goes from A1 & F2 thru A500 & F500 These totals are for each line/part number for whats being shipped out, with keeping overal total for what has been shipped for that part. I've been looking at different codes but havent found the information needed to make this happen. Hopefully it can but please advise with any assistance. Thanks!!!! |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
multiple line two accumulators
The totals are showing accumulative....as with the 5000 qty, 1000 were
shipped before along with the 2000 just shipped. giving a running total of 3000. nothing wrong with your math, just my way showing the example. "K Dales" wrote: I still don't quite get it: Are you trying to calculate the amount in "Total Shipped" (column F), or something else? How are you defining "accumulated total?" - accumulated for what? If there is no duplication in parts why is the total not simply Quantity - Quantity shipped (e.g. F2=D2-E2)? How did you get 2000 as the total shipped in your second line? I am either misunderstanding the problem or the math. "EED" wrote: Let me rephrase.... This is for incoming parts that we're dealing with. No duplicate part numbers either and its too keep track of total amt of parts shipped for THAT line. Which there could be up to 500 diff lines but needs only keep accumulative total per part/line. I can get an accumulator working for one line but I need this to work for all lines if need be. Ultimately the amt entered in E1 should accumulate to F1 - as E2/D2, E3/D3. Again this is only for each line/part number, not an overall total for certain parts or all parts. I hope this is more clear on what I need. the spreadsheet goes.... A B C D E F Date - Part number - Job number - Quantity - Quantity Shipped - Total Shipped today 1 XXX XXXX XXXX 5000 2000 3000 2 XXX XXXX XXXX 2500 1500 2000 3 4 Thanks! "K Dales" wrote: If I understand correctly, you want the value in column F to indicate the accumulated total (running total) of the amounts in column A for a particular part number (which is in another, unspecified column? I will have to use that column, so I will arbitrarily make it column C). You could use a worksheet formula such as this in your F column - it is written for F2; could be copied down in column F to work for the rest of the range - but only if you follow the relative/absolute references carefully: F2 = SUMIF($C$1:$C2,$C2,$A$1$A2) "EED" wrote: I'm able to get a two cell accumlator going but my problem is I have multiple lines that I need this for. Ex: A1(amt entered) F2(accum. total), which goes from A1 & F2 thru A500 & F500 These totals are for each line/part number for whats being shipped out, with keeping overal total for what has been shipped for that part. I've been looking at different codes but havent found the information needed to make this happen. Hopefully it can but please advise with any assistance. Thanks!!!! |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
multiple line two accumulators
OK, so getting back to that first line of the example - how did you know that
1000 had been shipped before? That is still not clear. Basically, your formula in F needs to be able to know where this 1000 comes from and add E to it, but I can't give the formula yet because I need to know how you are figuring that amount that was "shipped before." "EED" wrote: The totals are showing accumulative....as with the 5000 qty, 1000 were shipped before along with the 2000 just shipped. giving a running total of 3000. nothing wrong with your math, just my way showing the example. "K Dales" wrote: I still don't quite get it: Are you trying to calculate the amount in "Total Shipped" (column F), or something else? How are you defining "accumulated total?" - accumulated for what? If there is no duplication in parts why is the total not simply Quantity - Quantity shipped (e.g. F2=D2-E2)? How did you get 2000 as the total shipped in your second line? I am either misunderstanding the problem or the math. "EED" wrote: Let me rephrase.... This is for incoming parts that we're dealing with. No duplicate part numbers either and its too keep track of total amt of parts shipped for THAT line. Which there could be up to 500 diff lines but needs only keep accumulative total per part/line. I can get an accumulator working for one line but I need this to work for all lines if need be. Ultimately the amt entered in E1 should accumulate to F1 - as E2/D2, E3/D3. Again this is only for each line/part number, not an overall total for certain parts or all parts. I hope this is more clear on what I need. the spreadsheet goes.... A B C D E F Date - Part number - Job number - Quantity - Quantity Shipped - Total Shipped today 1 XXX XXXX XXXX 5000 2000 3000 2 XXX XXXX XXXX 2500 1500 2000 3 4 Thanks! "K Dales" wrote: If I understand correctly, you want the value in column F to indicate the accumulated total (running total) of the amounts in column A for a particular part number (which is in another, unspecified column? I will have to use that column, so I will arbitrarily make it column C). You could use a worksheet formula such as this in your F column - it is written for F2; could be copied down in column F to work for the rest of the range - but only if you follow the relative/absolute references carefully: F2 = SUMIF($C$1:$C2,$C2,$A$1$A2) "EED" wrote: I'm able to get a two cell accumlator going but my problem is I have multiple lines that I need this for. Ex: A1(amt entered) F2(accum. total), which goes from A1 & F2 thru A500 & F500 These totals are for each line/part number for whats being shipped out, with keeping overal total for what has been shipped for that part. I've been looking at different codes but havent found the information needed to make this happen. Hopefully it can but please advise with any assistance. Thanks!!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How show single line rather than multiple line with same desc in e | New Users to Excel | |||
| Multiple Line Graphs | Charts and Charting in Excel | |||
| display 1 line of multiple worksheets into multiple lines on 1 wks | Excel Worksheet Functions | |||
| Multiple line, two cell accumulators | Excel Programming | |||
| Adding separate accumulators for multiple cells | New Users to Excel | |||
Hybrid Mode
