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.

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: 14h 49m

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: 21h 32m
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: 1d 19m
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: 1d 24m
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: 1d 1h 7m
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: 1d 6h 6m
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: 1d 12h 32m
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: 1d 13h 12m
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: 1d 13h 28m
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: 1d 16h 50m
Buy It Now for only: $200.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
$6,750.00
Time Remaining: 1d 17h 2m
Buy It Now for only: $6,750.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: 1d 18h 10m
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: 1d 19h 52m
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: 1d 20h 47m
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: 1d 22h 23m
Buy It Now for only: $120.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: 2d 13h 48m
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: 2d 13h 48m
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: 2d 13h 48m
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: 2d 13h 48m
Buy It Now for only: $260.00

Imperial 10 Tilting Rotary Table CNC Machine Shop REPAIR
Imperial 10 Tilting Rotary Table CNC Machine Shop REPAIR
$400.00
Time Remaining: 2d 19h 32m
Buy It Now for only: $400.00

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: 3d 2h 38m
Buy It Now for only: $750.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: 3d 11h 2m
Buy It Now for only: $69.99

Vacuum Table for CNC Mill
Vacuum Table for CNC Mill
$98.00
Time Remaining: 3d 12h 2m
Buy It Now for only: $98.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: 3d 18h 59m
Buy It Now for only: $9,895.00

Haas CNC 4th axis controller control box for rotary table or indexer
Haas CNC 4th axis controller control box for rotary table or indexer
$985.00
Time Remaining: 3d 23h 19m
Buy It Now for only: $985.00

Haas CNC 4th axis controller control box for rotary table or indexer
Haas CNC 4th axis controller control box for rotary table or indexer
$985.00
Time Remaining: 3d 23h 22m
Buy It Now for only: $985.00

56 pounds Ultradex precision 90deg bracket 7 table to 12 or as CNC mill knee
56 pounds Ultradex precision 90deg bracket 7 table to 12 or as CNC mill knee
$95.00
Time Remaining: 4d 42m
Buy It Now for only: $125.00

Vacuum Table for CNC Mill
Vacuum Table for CNC Mill
$98.00
Time Remaining: 4d 10h 58m
Buy It Now for only: $98.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: 4d 13h 35m
Buy It Now for only: $3,895.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: 4d 15h 9m
Buy It Now for only: $4,012.95

Adjustable CNC Table Clamping Set 7 8 Inch T slot
Adjustable CNC Table Clamping Set 7 8 Inch T slot
$74.70
Time Remaining: 4d 17h 37m
Buy It Now for only: $74.70

cnc rotary table
cnc rotary table
$500.00
Time Remaining: 4d 18h 29m

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

OKUMA 7000 4TH AXIS CNC ROTARY TABLE NCR 240 WITH HOWA CHUCK 7003 H0921M8 S 884
OKUMA 7000 4TH AXIS CNC ROTARY TABLE NCR 240 WITH HOWA CHUCK 7003 H0921M8 S 884
$5,999.00
Time Remaining: 5d 13h 24m
Buy It Now for only: $8,999.00

Vacuum table VT6040GAL CNC CHUCK Engraving or Milling
Vacuum table VT6040GAL CNC CHUCK Engraving or Milling
$1,106.00
Time Remaining: 5d 15h 13m
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: 5d 16h 24m
Buy It Now for only: $14,900.00

Hardinge CHNC Cnc turret table 3 8 Tools
Hardinge CHNC Cnc turret table 3 8 Tools
$265.00
Time Remaining: 5d 20h 27m
Buy It Now for only: $265.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: 5d 20h 57m
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
$59,499.15
Time Remaining: 6d 11h 35m
Buy It Now for only: $59,499.15

Vacuum Table for CNC Mill 2 thk x 20 w x 44 long
Vacuum Table for CNC Mill 2 thk x 20 w x 44 long
$975.00
Time Remaining: 6d 14h 23m
Buy It Now for only: $975.00

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

Tsudakoma CNC 4th and 5th Axis Rotary Table Model TTNC 301 13 dia Table
Tsudakoma CNC 4th and 5th Axis Rotary Table Model TTNC 301 13 dia Table
$29,900.00
Time Remaining: 6d 20h 10m
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: 6d 21h 45m
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: 7d 1h 6m
Buy It Now for only: $10,950.00

PARKER DAEDAL X Y POSITIONING TABLE cnc 3d printer makerbot mach 3 linux
PARKER DAEDAL X Y POSITIONING TABLE cnc 3d printer makerbot mach 3 linux
$900.00
Time Remaining: 7d 1h 57m
Buy It Now for only: $1,299.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
$359.99
Time Remaining: 7d 7h 19m
Buy It Now for only: $359.99

SMW PT160 CNC 4th Axis Rotary Table Chuck Collet Indexer No Controls Pneumatic
SMW PT160 CNC 4th Axis Rotary Table Chuck Collet Indexer No Controls Pneumatic
$2,019.99
Time Remaining: 7d 18h 45m
Buy It Now for only: $2,019.99

SELF CENTERING 3 JAW LATHE CHUCK 100MM CNC ROTARY TABLE DIVIDING HEAD L3502
SELF CENTERING 3 JAW LATHE CHUCK 100MM CNC ROTARY TABLE DIVIDING HEAD L3502
$76.50
Time Remaining: 8d 6h 59m
Buy It Now for only: $76.50

SELF CENTERING 3 JAW LATHE CHUCK 80MM CNC ROTARY TABLE DIVIDING HEAD L3501
SELF CENTERING 3 JAW LATHE CHUCK 80MM CNC ROTARY TABLE DIVIDING HEAD L3501
$69.00
Time Remaining: 8d 7h 15m
Buy It Now for only: $69.00

CNC 4th Axis Rotary Table 100mm 4 inch with Gecko G540 DB9 connector
CNC 4th Axis Rotary Table 100mm 4 inch with Gecko G540 DB9 connector
$325.00
Time Remaining: 8d 11h 26m
Buy It Now for only: $325.00