P
Peter Gonzalez
I have some data that I gather up every day. This data concerns of Parts,
Quantities and work orders numbers. The parts have to be divided by
departments although I can never predict which parts are going to show up on
my data report nor how many. So what I do is divide the parts I get by text
color Red, Blue, Black. So what I wanted know was if there is a formula that
I can use to add up the values I get in Red, Blue, Black separately on to a
different sheet that I have set up for the totals.
My data sheet looks like this: (Example)
Column C Column D Column E Column G
Item # Qty. Ordered Qty. Completed Date
K20206-3731 288 (Blue) 283(Blue) 4/9/2010
R33943 1133(Black) 1065(Black) 4/9/2010
S14185 60(Red) 0(Red) 4/9/2010
S21747 567(Blue) 505(Blue) 4/9/2010
R34108 881(Black) 838(Black) 4/9/2010
S12029 1065(Red) 1061(Red) 4/9/2010
etc.
I want my totals Sheet to look like this:
Dept. A
Dates Qty. Ordered Qty. Completed
4/9/2010 Red total Red total
Dept. B
Dates Qty. Ordered Qty Completed
4/9/2010 Blue Total Blue Total
Dept. C
Dates Qty. Ordered Qty Completed
4/9/2010 Black Total Black Total
I get hundreds of parts and quantities every day so it kind of is time
consuming. Please help me and make my life easier.
Quantities and work orders numbers. The parts have to be divided by
departments although I can never predict which parts are going to show up on
my data report nor how many. So what I do is divide the parts I get by text
color Red, Blue, Black. So what I wanted know was if there is a formula that
I can use to add up the values I get in Red, Blue, Black separately on to a
different sheet that I have set up for the totals.
My data sheet looks like this: (Example)
Column C Column D Column E Column G
Item # Qty. Ordered Qty. Completed Date
K20206-3731 288 (Blue) 283(Blue) 4/9/2010
R33943 1133(Black) 1065(Black) 4/9/2010
S14185 60(Red) 0(Red) 4/9/2010
S21747 567(Blue) 505(Blue) 4/9/2010
R34108 881(Black) 838(Black) 4/9/2010
S12029 1065(Red) 1061(Red) 4/9/2010
etc.
I want my totals Sheet to look like this:
Dept. A
Dates Qty. Ordered Qty. Completed
4/9/2010 Red total Red total
Dept. B
Dates Qty. Ordered Qty Completed
4/9/2010 Blue Total Blue Total
Dept. C
Dates Qty. Ordered Qty Completed
4/9/2010 Black Total Black Total
I get hundreds of parts and quantities every day so it kind of is time
consuming. Please help me and make my life easier.