Hi, im creating a page on excel for ordering a custom pc.
I have sets of radio buttons for the different choices,
ie: o 100GB Hard Drive
o 200GB
o 300GB
o 400 GB
when you click the 400gb option, for example it would be option 4, so i
made a formula that when B1 = 4 then the value (price) is £100 or
whatever,
those formulas work fine, but the problem is i have all of the prices
in colums C, but im not able to add them all up to make a total price.
when i try and add the whole colums with the seperate prices it just
comes to 0.00
any ideas how i can solve this?
thanks ( let me know if i wasnt clear enough! )
--
evo182
------------------------------------------------------------------------
evo182's Profile:
http://www.excelforum.com/member.php...o&userid=30712
View this thread:
http://www.excelforum.com/showthread...hreadid=503793