New Posts  All Forums:Forum Nav:

excel help please!

post #1 of 12
Thread Starter 
hey all,

i work in I.T, but im crap with excel, basically, i started 3 weeks ago, and they hacve hard ware every where so im creating an excel spred sheet that automatically adds, subtracts etc, but what i want, is,

say for instance we have colum a = make of hard drive

a = make of hard drive
b= capicity
H7:H30 = interface I.E sata, pata scsi
D = qauntity

now what i want, is in colum h if anything apart from S-ata P-ata or SCSI is entered between H7:H30 then i want a box to appear and say error in input or just a cell that does that, myu boss showed me once quickly but he gone to lunch, he used something along the lines of =SUMIF(H7:H30<>0"error" but i cant remember

cheers people
the beast within
(13 items)
 
  
CPUGraphicsRAMCooling
2500k @ 4.8ghz ASUS 290 DirectCU II Gskill 8gb custom watercooling 1/2 ID rig 
OSMonitorPowerCase
win7 64 syncmaster SA3000 x2 Corsair CX750M Corsair Obsidium 650D 
  hide details  
Reply
the beast within
(13 items)
 
  
CPUGraphicsRAMCooling
2500k @ 4.8ghz ASUS 290 DirectCU II Gskill 8gb custom watercooling 1/2 ID rig 
OSMonitorPowerCase
win7 64 syncmaster SA3000 x2 Corsair CX750M Corsair Obsidium 650D 
  hide details  
Reply
post #2 of 12
for reference, type in =SUMIF in a cell and then hit the = symbol up top. It provides you with guidelines.
Once again...
(13 items)
 
  
CPUMotherboardGraphicsRAM
i7 920 [4.28GHz, HT] Asus P6T + Broadcom NetXtreme II VisionTek HD5850 [900/1200] + Galaxy GT240 2x4GB G.Skill Ripjaw X [1632 MHz] 
Hard DriveOSMonitorKeyboard
Intel X25-M 160GB + 3xRAID0 500GB 7200.12 Window 7 Pro 64 Acer H243H + Samsung 226BW XARMOR-U9BL  
PowerCaseMouseMouse Pad
Antec Truepower New 750W Li Lian PC-V2100 [10x120mm fans] Logitech G9 X-Trac Pro 
  hide details  
Reply
Once again...
(13 items)
 
  
CPUMotherboardGraphicsRAM
i7 920 [4.28GHz, HT] Asus P6T + Broadcom NetXtreme II VisionTek HD5850 [900/1200] + Galaxy GT240 2x4GB G.Skill Ripjaw X [1632 MHz] 
Hard DriveOSMonitorKeyboard
Intel X25-M 160GB + 3xRAID0 500GB 7200.12 Window 7 Pro 64 Acer H243H + Samsung 226BW XARMOR-U9BL  
PowerCaseMouseMouse Pad
Antec Truepower New 750W Li Lian PC-V2100 [10x120mm fans] Logitech G9 X-Trac Pro 
  hide details  
Reply
post #3 of 12
Thread Starter 
ive tried the help but its useless im using excel 2003
the beast within
(13 items)
 
  
CPUGraphicsRAMCooling
2500k @ 4.8ghz ASUS 290 DirectCU II Gskill 8gb custom watercooling 1/2 ID rig 
OSMonitorPowerCase
win7 64 syncmaster SA3000 x2 Corsair CX750M Corsair Obsidium 650D 
  hide details  
Reply
the beast within
(13 items)
 
  
CPUGraphicsRAMCooling
2500k @ 4.8ghz ASUS 290 DirectCU II Gskill 8gb custom watercooling 1/2 ID rig 
OSMonitorPowerCase
win7 64 syncmaster SA3000 x2 Corsair CX750M Corsair Obsidium 650D 
  hide details  
Reply
post #4 of 12
Thread Starter 
i just need the formula , then i can fiddle around with it and learn myself =-)
the beast within
(13 items)
 
  
CPUGraphicsRAMCooling
2500k @ 4.8ghz ASUS 290 DirectCU II Gskill 8gb custom watercooling 1/2 ID rig 
OSMonitorPowerCase
win7 64 syncmaster SA3000 x2 Corsair CX750M Corsair Obsidium 650D 
  hide details  
Reply
the beast within
(13 items)
 
  
CPUGraphicsRAMCooling
2500k @ 4.8ghz ASUS 290 DirectCU II Gskill 8gb custom watercooling 1/2 ID rig 
OSMonitorPowerCase
win7 64 syncmaster SA3000 x2 Corsair CX750M Corsair Obsidium 650D 
  hide details  
Reply
post #5 of 12
Thread Starter 
attached is my project! im only a newbie and my first go at a spreadsheet
the beast within
(13 items)
 
  
CPUGraphicsRAMCooling
2500k @ 4.8ghz ASUS 290 DirectCU II Gskill 8gb custom watercooling 1/2 ID rig 
OSMonitorPowerCase
win7 64 syncmaster SA3000 x2 Corsair CX750M Corsair Obsidium 650D 
  hide details  
Reply
the beast within
(13 items)
 
  
CPUGraphicsRAMCooling
2500k @ 4.8ghz ASUS 290 DirectCU II Gskill 8gb custom watercooling 1/2 ID rig 
OSMonitorPowerCase
win7 64 syncmaster SA3000 x2 Corsair CX750M Corsair Obsidium 650D 
  hide details  
Reply
post #6 of 12
Thread Starter 
feel free to check out my formulas for caulculating how many sata, pata, scsi drives are there amd what ever
the beast within
(13 items)
 
  
CPUGraphicsRAMCooling
2500k @ 4.8ghz ASUS 290 DirectCU II Gskill 8gb custom watercooling 1/2 ID rig 
OSMonitorPowerCase
win7 64 syncmaster SA3000 x2 Corsair CX750M Corsair Obsidium 650D 
  hide details  
Reply
the beast within
(13 items)
 
  
CPUGraphicsRAMCooling
2500k @ 4.8ghz ASUS 290 DirectCU II Gskill 8gb custom watercooling 1/2 ID rig 
OSMonitorPowerCase
win7 64 syncmaster SA3000 x2 Corsair CX750M Corsair Obsidium 650D 
  hide details  
Reply
post #7 of 12
Thread Starter 
??
the beast within
(13 items)
 
  
CPUGraphicsRAMCooling
2500k @ 4.8ghz ASUS 290 DirectCU II Gskill 8gb custom watercooling 1/2 ID rig 
OSMonitorPowerCase
win7 64 syncmaster SA3000 x2 Corsair CX750M Corsair Obsidium 650D 
  hide details  
Reply
the beast within
(13 items)
 
  
CPUGraphicsRAMCooling
2500k @ 4.8ghz ASUS 290 DirectCU II Gskill 8gb custom watercooling 1/2 ID rig 
OSMonitorPowerCase
win7 64 syncmaster SA3000 x2 Corsair CX750M Corsair Obsidium 650D 
  hide details  
Reply
post #8 of 12
Thread Starter 
oh btw i made a mistake, it doesnt need to add the hardware automatically, i will manually add the information, it will auto add the numebrs up and sort them in to catogories which ive done its just getting an error message to put up wen the wrong info has been entered
the beast within
(13 items)
 
  
CPUGraphicsRAMCooling
2500k @ 4.8ghz ASUS 290 DirectCU II Gskill 8gb custom watercooling 1/2 ID rig 
OSMonitorPowerCase
win7 64 syncmaster SA3000 x2 Corsair CX750M Corsair Obsidium 650D 
  hide details  
Reply
the beast within
(13 items)
 
  
CPUGraphicsRAMCooling
2500k @ 4.8ghz ASUS 290 DirectCU II Gskill 8gb custom watercooling 1/2 ID rig 
OSMonitorPowerCase
win7 64 syncmaster SA3000 x2 Corsair CX750M Corsair Obsidium 650D 
  hide details  
Reply
post #9 of 12
How about this for restricting what values are entered in H7:H30...

Use Data Validation (List) - where the list is located @ BA1:BA3

Basically when you need to enter a drive interface type, just select it from the drop down list in the column. BTW, it will only let you select a interface type from the list, you can't just type anything in there or you will get an error message.

If you need anything else, just let me know.
post #10 of 12
Thread Starter 
hey cheers man that has helped alot, reakon you could take a few screen shots of how you did it? me and my boss are racking our brains trying to remember cheers man ur a star
the beast within
(13 items)
 
  
CPUGraphicsRAMCooling
2500k @ 4.8ghz ASUS 290 DirectCU II Gskill 8gb custom watercooling 1/2 ID rig 
OSMonitorPowerCase
win7 64 syncmaster SA3000 x2 Corsair CX750M Corsair Obsidium 650D 
  hide details  
Reply
the beast within
(13 items)
 
  
CPUGraphicsRAMCooling
2500k @ 4.8ghz ASUS 290 DirectCU II Gskill 8gb custom watercooling 1/2 ID rig 
OSMonitorPowerCase
win7 64 syncmaster SA3000 x2 Corsair CX750M Corsair Obsidium 650D 
  hide details  
Reply
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Coding and Programming