2-play

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

DuckieHo

for reference, type in =SUMIF in a cell and then hit the = symbol up top. It provides you with guidelines.

__________________
WANTED: Socket M Core/Core 2 CPU, SUGO-02 Black, quality 802.11b/g PCI Card
To answer most of your questions: (1) a fridge cannot cool a PC (2) 64-bit OS for over 3.4GB (3) If a PCIe card fits, it will work (4) Resolution, not screen size (5) If you have a question, it is not news (6) Report, not respond to Spam (7) Single/Non-Modular Rail PSUs are NOT better than Multi-Rail/Modular

2-play

ive tried the help but its useless im using excel 2003

__________________
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

2-play

i just need the formula , then i can fiddle around with it and learn myself =-)

__________________
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

2-play

attached is my project! im only a newbie and my first go at a spreadsheet

Attached Files

Hardware.zip (4.1 KB, 3 views)

__________________
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

2-play

feel free to check out my formulas for caulculating how many sata, pata, scsi drives are there amd what ever

__________________
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

2-play

??

__________________
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

2-play

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

__________________
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

falcon2099

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.

Attached Files

HardwareNEW(w Data Validation).zip (4.5 KB, 4 views)

__________________
CPU-Z Validated:
http://valid.x86-secret.com/show_oc.php?id=286288

On RMA:

WishList:
1. 19" (or 21") LCD monitor
2. CPU (Core 2 Duo) will need new mobo for this... only rev2 of the P5LD2 support the C2D's - I guess I'll wait 'til the Pentium D is like the P3 and grossly obsolete

There are only 10 kinds of people in the world today: Those who speak binary, and those who don't.

2-play

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

__________________
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.