Table Cnc

Excel Question(spreadsheet, budget) HELP! plz :) ?

I have a spreedsheet with 2 tables.

One table has a coulumn B( Code) and column E(which has the amount spent for that code)

In the second table, i have coulumn G (which has the codes once again, but only one of each this time) and column H(which adds up all the amounts per code)
for example, in coulumn H i have this equation:

=SUMIF(B12:B73,"CNC ",E12:E73)

however, the code is not always going to be CNC. So how can i add an equation that will do this. If Column G code changes, then change the code in the eqation to that code....I can send u the sheet if u gie me ur email...mine is mariahmartinez@earthlink.net

assume that column G starts at G1
then just change your formula in H1 to this

=SUMIF(B12:B73,G1,E12:E73)

if column G starts at any other row, just adjust the formula

then copy the cell and paste down the column.
but if you do that, then you want to use this instead

=SUMIF(B$12:B$73,G1,E$12:E$73)

feel free to email me.

Adjustable CNC Table Clamping Set 11 16 T slot New
Adjustable CNC Table Clamping Set 11 16 T slot New
$50.35
Time Remaining: 1h 9m
Buy It Now for only: $50.35

bridgeport cnc vertical mill 9X42 table
bridgeport cnc vertical mill 9X42 table
$4,200.00
Time Remaining: 4h 19m

Te Co 3 8 Table T Slot x 5 16 18 Workholding CNC Milling Machine Clamp Kit
Te Co 3 8 Table T Slot x 5 16 18 Workholding CNC Milling Machine Clamp Kit
$205.00
Time Remaining: 6h 56m

Te Co 5 8 Table T Slot x 1 2 13 Bridgeport CNC Milling Machine Clamp Kit
Te Co 5 8 Table T Slot x 1 2 13 Bridgeport CNC Milling Machine Clamp Kit
$215.00
Time Remaining: 6h 56m

Vacuum table VTZ1610TRAL CNC CHUCK Engraving or Milling
Vacuum table VTZ1610TRAL CNC CHUCK Engraving or Milling
$449.00
Time Remaining: 21h 2m
Buy It Now for only: $449.00

IKAGAI VT1100 CNC Vertical Turrett Lathe 495 Table 4 jaw
IKAGAI VT1100 CNC Vertical Turrett Lathe 495 Table 4 jaw
$14,000.00
Time Remaining: 21h 15m

Vacuum table VTZ4824 CNC Clamps Engraving or Milling
Vacuum table VTZ4824 CNC Clamps Engraving or Milling
$1,189.00
Time Remaining: 22h 2m
Buy It Now for only: $1,189.00

Nikken Kosakusho Multi Spindle CNC Rotary Table CNC 100 3W120 100 mm
Nikken Kosakusho Multi Spindle CNC Rotary Table CNC 100 3W120 100 mm
$1,000.00
Time Remaining: 22h 19m
Buy It Now for only: $1,000.00

TANSHING model TRNC 125H 5 Diameter CNC 5th Axis Rotary Table 2 Axis Trunnion
TANSHING model TRNC 125H 5 Diameter CNC 5th Axis Rotary Table 2 Axis Trunnion
$7,900.00
Time Remaining: 1d 26m
Buy It Now for only: $7,900.00

TROYKE 10 CNC ROTARY TABLE
TROYKE 10 CNC ROTARY TABLE
$2,950.00
Time Remaining: 1d 1h 23m
Buy It Now for only: $2,950.00

KENSINGTON LABORATORIES 6 CNC ROTARY STAGE TABLE w MAXON DC MOTOR
KENSINGTON LABORATORIES 6 CNC ROTARY STAGE TABLE w MAXON DC MOTOR
$51.00 (13 Bids)
Time Remaining: 1d 11h 39m

GERMANY TILTING ROTARY TABLE VERTICAL HORI ZONTAL MILLING FITS HAAS ANY CNC
GERMANY TILTING ROTARY TABLE VERTICAL HORI ZONTAL MILLING FITS HAAS ANY CNC
$2,895.00
Time Remaining: 2d 16m
Buy It Now for only: $3,895.00

cnc mill table top 3 axis 215 x 105 x 5 2HP CNC Masters Max new machine
cnc mill table top 3 axis 215 x 105 x 5 2HP CNC Masters Max new machine
$6,500.00
Time Remaining: 2d 1h 46m

CNC Engraving Machine H Rotary Table Jaw Chuck Rotational A B Axis 4th
CNC Engraving Machine H Rotary Table Jaw Chuck Rotational A B Axis 4th
$379.99
Time Remaining: 2d 13h 11m
Buy It Now for only: $379.99

MORI SEIKI CNC HORIZONTAL MACHINING CENTER SH 400 PARAMETERS TABLE MANUAL
MORI SEIKI CNC HORIZONTAL MACHINING CENTER SH 400 PARAMETERS TABLE MANUAL
$200.00
Time Remaining: 2d 23h 55m
Buy It Now for only: $200.00

HAAS TWO AXIS CONTROL BOX 4TH 5TH CNC MILL ROTARY TABLE INDEXER HRT 210 HA5C
HAAS TWO AXIS CONTROL BOX 4TH 5TH CNC MILL ROTARY TABLE INDEXER HRT 210 HA5C
$1,895.00
Time Remaining: 3d 1h 16m
Buy It Now for only: $1,895.00

2004 CNC Hardinge 5C Rotary Indexer w Servo Control  Tailstock 4th Axis Table
2004 CNC Hardinge 5C Rotary Indexer w Servo Control Tailstock 4th Axis Table
$4,567.89
Time Remaining: 4d 1h 1m

Imperial 10 Tilting Rotary Table CNC Machine Shop REPAIR
Imperial 10 Tilting Rotary Table CNC Machine Shop REPAIR
$500.00
Time Remaining: 4d 2h 38m
Buy It Now for only: $500.00

TSUDAKOMA RN 200 R ROTARY TABLE 4th AXIS CNC with Cables
TSUDAKOMA RN 200 R ROTARY TABLE 4th AXIS CNC with Cables
$1,500.00
Time Remaining: 4d 3h 38m

Haas cnc 4th axis controller control box for rotary table or indexer 17 pin red
Haas cnc 4th axis controller control box for rotary table or indexer 17 pin red
$750.00
Time Remaining: 4d 9h 44m
Buy It Now for only: $750.00

Te Co 3 8 Table T Slot x 5 16 18 Workholding CNC Milling Machine Clamp Kit
Te Co 3 8 Table T Slot x 5 16 18 Workholding CNC Milling Machine Clamp Kit
$205.00
Time Remaining: 4d 14h 34m
Buy It Now for only: $205.00

Te Co 1 2 Table T Slot x 3 8 16 Workholding CNC Milling Machine Clamp Kit
Te Co 1 2 Table T Slot x 3 8 16 Workholding CNC Milling Machine Clamp Kit
$190.00
Time Remaining: 4d 14h 34m
Buy It Now for only: $190.00

Te Co 5 8 Table T Slot x 1 2 13 Bridgeport CNC Milling Machine Clamp Kit
Te Co 5 8 Table T Slot x 1 2 13 Bridgeport CNC Milling Machine Clamp Kit
$215.00
Time Remaining: 4d 14h 35m
Buy It Now for only: $215.00

Te Co 3 4 Table T Slot x 5 8 11 Workholding CNC Milling Machine Clamp Kit
Te Co 3 4 Table T Slot x 5 8 11 Workholding CNC Milling Machine Clamp Kit
$260.00
Time Remaining: 4d 14h 35m
Buy It Now for only: $260.00

Vacuum table VT2010RAL CNC Chuck Engraving or Milling  clamping
Vacuum table VT2010RAL CNC Chuck Engraving or Milling clamping
$110.00
Time Remaining: 4d 21h 25m
Buy It Now for only: $110.00

KOMO 3 AXIS 50 120 CNC VERTICAL MACHINING CENTER 50 TAPER 32 X 120 TABLE
KOMO 3 AXIS 50 120 CNC VERTICAL MACHINING CENTER 50 TAPER 32 X 120 TABLE
$69,500.00
Time Remaining: 5d 2h 4m
Buy It Now for only: $69,500.00

NICE  10 Kitagawa 4th Axis CNC Rotary Table CNC Indexer model TM250A4J02
NICE 10 Kitagawa 4th Axis CNC Rotary Table CNC Indexer model TM250A4J02
$9,895.00
Time Remaining: 5d 2h 5m
Buy It Now for only: $9,895.00

Adjustable CNC Table Clamping Set 7 8 Inch T slot
Adjustable CNC Table Clamping Set 7 8 Inch T slot
$74.70
Time Remaining: 6d 42m
Buy It Now for only: $74.70

Troyke CNC 12 Inch Tilting Rotary Table TIL12CNC1970 Inv12620
Troyke CNC 12 Inch Tilting Rotary Table TIL12CNC1970 Inv12620
$6,500.00
Time Remaining: 6d 20h 26m
Buy It Now for only: $6,500.00

Vacuum table VT6040GAL CNC CHUCK Engraving or Milling
Vacuum table VT6040GAL CNC CHUCK Engraving or Milling
$1,106.00
Time Remaining: 6d 22h 18m
Buy It Now for only: $1,106.00

TSUDAKOMA 4 AXIS 5 AXIS TRUNNION TILTING ROTARY TABLE CNC
TSUDAKOMA 4 AXIS 5 AXIS TRUNNION TILTING ROTARY TABLE CNC
$14,900.00
Time Remaining: 6d 23h 30m
Buy It Now for only: $14,900.00

LINEAR BALL BEARINGS XYZ TABLE CNC ROUTER AXIS SLIDE 2 20 x 32 x 42
LINEAR BALL BEARINGS XYZ TABLE CNC ROUTER AXIS SLIDE 2 20 x 32 x 42
$9.99
Time Remaining: 7d 4h 3m
Buy It Now for only: $9.99

Wendespanner Peiseler Typ  EW 1000 CNC rotary table  Wheel Pulse
Wendespanner Peiseler Typ EW 1000 CNC rotary table Wheel Pulse
$69,999.00
Time Remaining: 7d 18h 40m
Buy It Now for only: $69,999.00

Hofmann CNC 4th  5th Axis 25 dia Rotary Tilting Table MPRS NC630 Fanuc Motors
Hofmann CNC 4th 5th Axis 25 dia Rotary Tilting Table MPRS NC630 Fanuc Motors
$25,000.00
Time Remaining: 8d 3h 5m
Buy It Now for only: $25,000.00

Tsudakoma CNC 4th  5th Axis Rotary Tilting Table Model TTNC 301 13 dia Table
Tsudakoma CNC 4th 5th Axis Rotary Tilting Table Model TTNC 301 13 dia Table
$29,900.00
Time Remaining: 8d 3h 16m
Buy It Now for only: $29,900.00

12 Troyke Diameter Index Rotary Table Roto Indexer CNC AH 12 AH12
12 Troyke Diameter Index Rotary Table Roto Indexer CNC AH 12 AH12
$400.00
Time Remaining: 8d 4h 50m
Buy It Now for only: $400.00

TSUDAKOMA 4 AXIS 5 AXIS TRUNNION TILTING ROTARY TABLE CNC
TSUDAKOMA 4 AXIS 5 AXIS TRUNNION TILTING ROTARY TABLE CNC
$10,950.00
Time Remaining: 8d 8h 12m
Buy It Now for only: $10,950.00

CNC Engraving Machine Rotary Table H Style A Axis B Axis4th5th Rotational Axis
CNC Engraving Machine Rotary Table H Style A Axis B Axis4th5th Rotational Axis
$341.99
Time Remaining: 8d 14h 25m
Buy It Now for only: $341.99

Aerotech Accudex CNC Single Axis Slide Table Linear Positioner ATS02005 U 40P
Aerotech Accudex CNC Single Axis Slide Table Linear Positioner ATS02005 U 40P
$2,000.00
Time Remaining: 8d 19h 38m
Buy It Now for only: $2,000.00

Aerotech Accudex CNC Single Axis Slide Table Linear Positioner ATS0205U40P
Aerotech Accudex CNC Single Axis Slide Table Linear Positioner ATS0205U40P
$2,000.00
Time Remaining: 8d 19h 46m
Buy It Now for only: $2,000.00

Aerotech Accudex CNC Single Axis Slide Table Linear Positioner ATS02005 U 40P
Aerotech Accudex CNC Single Axis Slide Table Linear Positioner ATS02005 U 40P
$2,000.00
Time Remaining: 8d 19h 50m
Buy It Now for only: $2,000.00

Aerotech Accudex CNC Single Axis Slide Table Linear Positioner ATS202
Aerotech Accudex CNC Single Axis Slide Table Linear Positioner ATS202
$1,250.00
Time Remaining: 8d 20h 7m
Buy It Now for only: $1,250.00

Aerotech Accudex CNC Single Axis Slide Table Linear Positioner ATS100 50 U 20P
Aerotech Accudex CNC Single Axis Slide Table Linear Positioner ATS100 50 U 20P
$700.00
Time Remaining: 8d 20h 11m
Buy It Now for only: $700.00

Russell T Gilman Incorporated CNC Single Axis Slide Table Linear Positioner
Russell T Gilman Incorporated CNC Single Axis Slide Table Linear Positioner
$350.00
Time Remaining: 8d 20h 16m
Buy It Now for only: $350.00

Aerotech Accudex CNC Single Axis Slide Table Linear Positioner ATS205U40P
Aerotech Accudex CNC Single Axis Slide Table Linear Positioner ATS205U40P
$1,250.00
Time Remaining: 8d 20h 35m
Buy It Now for only: $1,250.00

Aerotech Accudex CNC Single Axis Slide Table Linear Positioner ATS202
Aerotech Accudex CNC Single Axis Slide Table Linear Positioner ATS202
$1,250.00
Time Remaining: 8d 20h 40m
Buy It Now for only: $1,250.00

Aerotech Accudex CNC Single Axis Slide Table Linear Positioner ATS0205U40P
Aerotech Accudex CNC Single Axis Slide Table Linear Positioner ATS0205U40P
$1,250.00
Time Remaining: 8d 20h 58m
Buy It Now for only: $1,250.00

Parker Pos Systems DRC CNC Double Axis Slide Table Linear Positioner 02 94
Parker Pos Systems DRC CNC Double Axis Slide Table Linear Positioner 02 94
$1,750.00
Time Remaining: 8d 21h 8m
Buy It Now for only: $1,750.00

Parker Pos Systems DRC CNC Single Axis Slide Table Linear Positioner 04 93
Parker Pos Systems DRC CNC Single Axis Slide Table Linear Positioner 04 93
$1,750.00
Time Remaining: 8d 21h 10m
Buy It Now for only: $1,750.00

Troyke L 10 L Series Indexing Rotary 5th Axis Tilting Table CNC Parker BE344LQ
Troyke L 10 L Series Indexing Rotary 5th Axis Tilting Table CNC Parker BE344LQ
$3,999.99
Time Remaining: 8d 23h 21m