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.

10 Dapra Walter Full 4th Axis CNC Rotary Table CNC Indexer
10 Dapra Walter Full 4th Axis CNC Rotary Table CNC Indexer
$3,400.00
Time Remaining: 1h 15m
Buy It Now for only: $3,400.00

Haas CNC Indexer Table Box Servo Control
Haas CNC Indexer Table Box Servo Control
$1,000.00
Time Remaining: 1h 47m
Buy It Now for only: $1,000.00

SMW RT 160 PY Rotary Indexer CNC 4th Axis Rotary Table Accu Smart 55 Control Box
SMW RT 160 PY Rotary Indexer CNC 4th Axis Rotary Table Accu Smart 55 Control Box
$4,400.00
Time Remaining: 7h 27m
Buy It Now for only: $4,400.00

NICE  Troyke 9 DL 9 B Full 4th Axis CNC Rotary Table CNC Indexer Centroid CNC
NICE Troyke 9 DL 9 B Full 4th Axis CNC Rotary Table CNC Indexer Centroid CNC
$3,400.00
Time Remaining: 7h 27m
Buy It Now for only: $3,400.00

Troyke 15 CNC Rotary Table full 4th Axis Indexer Haas VF BIG BORE THRU HOLE
Troyke 15 CNC Rotary Table full 4th Axis Indexer Haas VF BIG BORE THRU HOLE
$10,900.00
Time Remaining: 7h 27m
Buy It Now for only: $10,900.00

Troyke 5C Dual Head Rotary Table Full Fourth 4th Axis CNC Indexer
Troyke 5C Dual Head Rotary Table Full Fourth 4th Axis CNC Indexer
$4,900.00
Time Remaining: 7h 27m
Buy It Now for only: $4,900.00

5 Axis CNC Rotary Table Fixture for Horizontal Machining Center 4th and 5th Axis
5 Axis CNC Rotary Table Fixture for Horizontal Machining Center 4th and 5th Axis
$7,800.00
Time Remaining: 7h 27m
Buy It Now for only: $7,800.00

4th Axis CNC Indexer 8 Tsudakoma Rotary Table Full Fourth CNC Indexer Centroid
4th Axis CNC Indexer 8 Tsudakoma Rotary Table Full Fourth CNC Indexer Centroid
$4,500.00
Time Remaining: 7h 27m
Buy It Now for only: $4,500.00

Supermax 3 Axis CNC Milling Machine W power draw Bar 40 Taper 48 Table Tools
Supermax 3 Axis CNC Milling Machine W power draw Bar 40 Taper 48 Table Tools
$8,295.00
Time Remaining: 17h 41m
Buy It Now for only: $8,295.00

Hofman RMH 500 cnc 4th axis rotary table pendant and controller mill milling
Hofman RMH 500 cnc 4th axis rotary table pendant and controller mill milling
$2,950.00
Time Remaining: 1d 3h 4m
Buy It Now for only: $2,950.00

FADAL MODEL TR 165 5TH AXIS CNC TRUNION ROTARY TABLE FOR VMC 6 1 2 PLATE
FADAL MODEL TR 165 5TH AXIS CNC TRUNION ROTARY TABLE FOR VMC 6 1 2 PLATE
$12,000.00
Time Remaining: 1d 7h 28m
Buy It Now for only: $12,000.00

Tailstock 3 1 2 Center cnc rotary table milling tail stock atlas index fixture
Tailstock 3 1 2 Center cnc rotary table milling tail stock atlas index fixture
$69.99
Time Remaining: 1d 12h 34m
Buy It Now for only: $69.99

Radial Arm Drill Tilting Rotating Box Table ooya carlton ikeda arboga wilton cnc
Radial Arm Drill Tilting Rotating Box Table ooya carlton ikeda arboga wilton cnc
$1,250.00
Time Remaining: 1d 15h 49m
Buy It Now for only: $1,250.00

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,995.00
Time Remaining: 1d 23h 36m
Buy It Now for only: $3,895.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: 2d 2h 28m

25 Walter CNC Rotary Table RiL 630K with Mitsubishi Servo Motor
25 Walter CNC Rotary Table RiL 630K with Mitsubishi Servo Motor
$3,750.00
Time Remaining: 2d 12h 20m
Buy It Now for only: $3,750.00

542B 84 LUCAS 5 Five Axis CNC Table Type Horizontal Boring Mill 2001 Retrofit
542B 84 LUCAS 5 Five Axis CNC Table Type Horizontal Boring Mill 2001 Retrofit
$199,500.00
Time Remaining: 2d 14h 35m
Buy It Now for only: $199,500.00

Torchmate 2x2 Growth Series Table Top CNC System Plasma Basic Package
Torchmate 2x2 Growth Series Table Top CNC System Plasma Basic Package
$2,000.00
Time Remaining: 2d 16h 43m
Buy It Now for only: $4,012.95

Haas Brosh Type CNC Rotary Table Indexer HRT 210 with 11 Face Plate 3690
Haas Brosh Type CNC Rotary Table Indexer HRT 210 with 11 Face Plate 3690
$5,500.00
Time Remaining: 2d 16h 50m
Buy It Now for only: $5,500.00

GOLDEN SUN INDUSTRIAL NO CNCRB 321RV CNC INDEX ROTARY TABLE
GOLDEN SUN INDUSTRIAL NO CNCRB 321RV CNC INDEX ROTARY TABLE
$7,500.00
Time Remaining: 2d 18h 3m
Buy It Now for only: $7,500.00

542B 84 LUCAS 5 Five Axis CNC Table Type Horizontal Boring Mill 1996 Retrofit
542B 84 LUCAS 5 Five Axis CNC Table Type Horizontal Boring Mill 1996 Retrofit
$179,500.00
Time Remaining: 2d 18h 26m
Buy It Now for only: $179,500.00

CUSHMAN 8 AIR FLASH AUTO CNC MILL ROTARY TABLE TAIL STOCK
CUSHMAN 8 AIR FLASH AUTO CNC MILL ROTARY TABLE TAIL STOCK
$500.00
Time Remaining: 2d 20h 7m
Buy It Now for only: $500.00

TSUDAKOMA RNCV201R ROTARY TABLE 4th AXIS CNC WITH 3 jaw chuck and tail stock
TSUDAKOMA RNCV201R ROTARY TABLE 4th AXIS CNC WITH 3 jaw chuck and tail stock
$2,000.00
Time Remaining: 2d 23h 25m

Mitsubishi CNC EDM  2575 x 1775 x 6 Layout Steel Table off M55K
Mitsubishi CNC EDM 2575 x 1775 x 6 Layout Steel Table off M55K
$365.00
Time Remaining: 3d 11m
Buy It Now for only: $365.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: 3d 27m

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: 3d 27m

VISE SWIVEL BASE BRIDGEPORT MACHINE LATHE TOOLING CNC KURT TYPE CHUCK TURN TABLE
VISE SWIVEL BASE BRIDGEPORT MACHINE LATHE TOOLING CNC KURT TYPE CHUCK TURN TABLE
$75.00
Time Remaining: 3d 16h 9m
Buy It Now for only: $75.00

Adjustable CNC Table Clamping Set 11 16 T slot NEW
Adjustable CNC Table Clamping Set 11 16 T slot NEW
$50.35
Time Remaining: 3d 19h 37m
Buy It Now for only: $50.35

CNC 4th Axis Rotary Table 100mm 4 inch with MicroProto 6 Pin DIN MPS 2000
CNC 4th Axis Rotary Table 100mm 4 inch with MicroProto 6 Pin DIN MPS 2000
$325.00
Time Remaining: 4d 12h 13m
Buy It Now for only: $325.00

Vacuum table VTZ1610TRAL CNC CHUCK Engraving or Milling
Vacuum table VTZ1610TRAL CNC CHUCK Engraving or Milling
$449.00
Time Remaining: 4d 15h 30m
Buy It Now for only: $449.00

Vacuum table VTZ4824 CNC Clamps Engraving or Milling
Vacuum table VTZ4824 CNC Clamps Engraving or Milling
$1,189.00
Time Remaining: 4d 16h 30m
Buy It Now for only: $1,189.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: 4d 18h 54m
Buy It Now for only: $7,900.00

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

New Ganro CNC 631RV Rotary Table 4th Axis Fanuc Servo motor
New Ganro CNC 631RV Rotary Table 4th Axis Fanuc Servo motor
$24,500.00
Time Remaining: 4d 20h 31m
Buy It Now for only: $24,500.00

CNC vertical Mill Clausing Kondia Model FV 1 Power Feed 4 Axis 9x48 Table
CNC vertical Mill Clausing Kondia Model FV 1 Power Feed 4 Axis 9x48 Table
$3,900.00
Time Remaining: 4d 23h 48m

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: 5d 27m

CNC TABLE XY 14x 14 TRI SIGMA CORPORATION 21808600 21 8312 06
CNC TABLE XY 14x 14 TRI SIGMA CORPORATION 21808600 21 8312 06
$575.00
Time Remaining: 5d 16h 23m

MORI SEIKI MV 55 50 WITH 4th AXIS ROTARY TABLE FREE LOADING CAT 50 CNC MILL
MORI SEIKI MV 55 50 WITH 4th AXIS ROTARY TABLE FREE LOADING CAT 50 CNC MILL
$36,000.00
Time Remaining: 5d 23h 6m
Buy It Now for only: $36,000.00

SMW CNC Rotary Table Indexer Parts O Ring Kit PN 51160043 RT250
SMW CNC Rotary Table Indexer Parts O Ring Kit PN 51160043 RT250
$24.95
Time Remaining: 6d 1h 52m
Buy It Now for only: $24.95

SMW CNC Rotary Table Indexer Parts O Ring Kit PN 71120102 Pallet Changer
SMW CNC Rotary Table Indexer Parts O Ring Kit PN 71120102 Pallet Changer
$29.95
Time Remaining: 6d 1h 57m
Buy It Now for only: $29.95

HY 5 Axis Table H Workbench CNC Rotary Table
HY 5 Axis Table H Workbench CNC Rotary Table
$390.50
Time Remaining: 6d 2h 40m
Buy It Now for only: $390.50

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
$399.99
Time Remaining: 6d 7h 39m
Buy It Now for only: $399.99

CNC 4th Axis Rotary Table 100mm 4 inch with Flying Leads
CNC 4th Axis Rotary Table 100mm 4 inch with Flying Leads
$315.00
Time Remaining: 6d 14h 6m
Buy It Now for only: $315.00

10 Piece Clamping Kit for 100mm 4 inch CNC 4th Axis Rotary Table
10 Piece Clamping Kit for 100mm 4 inch CNC 4th Axis Rotary Table
$39.00
Time Remaining: 6d 14h 46m
Buy It Now for only: $39.00

80mm 3 inch Chuck with Backplate for CNC 4th Axis Rotary Table
80mm 3 inch Chuck with Backplate for CNC 4th Axis Rotary Table
$112.00
Time Remaining: 6d 15h 2m
Buy It Now for only: $112.00

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: 6d 18h 23m
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: 6d 19h 44m
Buy It Now for only: $1,895.00

NSK CNC ROTARY INDEXING TABLE INDEXER 875 FACE 4th AXIS CNC
NSK CNC ROTARY INDEXING TABLE INDEXER 875 FACE 4th AXIS CNC
$1,985.00
Time Remaining: 6d 21h 25m
Buy It Now for only: $1,985.00

Questech Microbot Choice Student Trainer Table Top CNC Mill Lathe FREE SHIPPING
Questech Microbot Choice Student Trainer Table Top CNC Mill Lathe FREE SHIPPING
$799.99
Time Remaining: 6d 22h 20m
Buy It Now for only: $799.99

Vacuum table VT3030 CNC CHUCK Engraving or Milling
Vacuum table VT3030 CNC CHUCK Engraving or Milling
$120.00
Time Remaining: 6d 23h 56m
Buy It Now for only: $120.00