If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Addition base on condition
Hello you all,
I have the following problem with a production sheet: A B, C, etc =the names of thr products next column = production time next column = addition of production times. Each time the production changes the cumulative time should restart. Have tried a couple of function like SUMIF but never succeeded. I 'll be gratefull for any suggestion 68magnolia71 A 05:15 5:15 A 06:15 11:30 B 07:15 7:15 C 08:15 8:15 C 09:15 17:30 C 04:15 21:45 |
#2
|
|||
|
|||
Hi what do you mean exactly by
" Each time the production changes the cumulative time should restart." with the first line of your example A 05:15 5:15 do you want to see this .... A 07:30 0 -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "68magnolia71" wrote in message ... Hello you all, I have the following problem with a production sheet: A B, C, etc =the names of thr products next column = production time next column = addition of production times. Each time the production changes the cumulative time should restart. Have tried a couple of function like SUMIF but never succeeded. I 'll be gratefull for any suggestion 68magnolia71 A 05:15 5:15 A 06:15 11:30 B 07:15 7:15 C 08:15 8:15 C 09:15 17:30 C 04:15 21:45 |
#3
|
|||
|
|||
Hello Julie,
For example: I did two batches of product "A" thus I sum the time spent = 5:15 + 6:15 total = 11:30 hours. Then I did 1 bach of product B time spent = 7:15 hours. Then I did 3 batches of product C, time spent: 8:15 + 9:15 4:15, total time = 21:45 hours. So what I meant is that each time the name of the product changes I will have to restart the spent time so that I can calculate the capacity of the workshop: so many tons in so many hours. I might have empty rows between the operations. For example the first batch of product A could be on row 1, the next one on row 10, with intermediate steps for batch 1 in the rows 2 through 9 but no calculations. Hopefully this will help you to built a formula. Thank you anyway. 68magnolia71. "JulieD" wrote: Hi what do you mean exactly by " Each time the production changes the cumulative time should restart." with the first line of your example A 05:15 5:15 do you want to see this .... A 07:30 0 -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "68magnolia71" wrote in message ... Hello you all, I have the following problem with a production sheet: A B, C, etc =the names of thr products next column = production time next column = addition of production times. Each time the production changes the cumulative time should restart. Have tried a couple of function like SUMIF but never succeeded. I 'll be gratefull for any suggestion 68magnolia71 A 05:15 5:15 A 06:15 11:30 B 07:15 7:15 C 08:15 8:15 C 09:15 17:30 C 04:15 21:45 |
#4
|
|||
|
|||
If I understand you correctly:
C1: =SUMIF($A$1:$A1,A1,$B$1:$B1) Format as a time, and copy down as far as necessary. In article , 68magnolia71 wrote: Hello Julie, For example: I did two batches of product "A" thus I sum the time spent = 5:15 + 6:15 total = 11:30 hours. Then I did 1 bach of product B time spent = 7:15 hours. Then I did 3 batches of product C, time spent: 8:15 + 9:15 4:15, total time = 21:45 hours. So what I meant is that each time the name of the product changes I will have to restart the spent time so that I can calculate the capacity of the workshop: so many tons in so many hours. I might have empty rows between the operations. For example the first batch of product A could be on row 1, the next one on row 10, with intermediate steps for batch 1 in the rows 2 through 9 but no calculations. Hopefully this will help you to built a formula. Thank you anyway. |
#5
|
|||
|
|||
Hello JE,
The formula works fine. Thank you very much indeed. Nevertheless it remains a dark world for me. Cannot understand why it is like it is.Never mind. 68magnolia71. "JE McGimpsey" wrote: If I understand you correctly: C1: =SUMIF($A$1:$A1,A1,$B$1:$B1) Format as a time, and copy down as far as necessary. In article , 68magnolia71 wrote: Hello Julie, For example: I did two batches of product "A" thus I sum the time spent = 5:15 + 6:15 total = 11:30 hours. Then I did 1 bach of product B time spent = 7:15 hours. Then I did 3 batches of product C, time spent: 8:15 + 9:15 4:15, total time = 21:45 hours. So what I meant is that each time the name of the product changes I will have to restart the spent time so that I can calculate the capacity of the workshop: so many tons in so many hours. I might have empty rows between the operations. For example the first batch of product A could be on row 1, the next one on row 10, with intermediate steps for batch 1 in the rows 2 through 9 but no calculations. Hopefully this will help you to built a formula. Thank you anyway. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Amend formula to include addition condition | Pat | Worksheet Functions | 1 | March 16th, 2005 03:36 PM |
Office 2003 installation problem, log file attached.... | Ryan | Setup, Installing & Configuration | 0 | January 20th, 2005 06:57 PM |
Data Base Size | TomC | General Discussion | 1 | December 2nd, 2004 07:46 PM |
Condition 1 OR Condition 2 | Martin | Running & Setting Up Queries | 2 | August 23rd, 2004 03:38 PM |