how to set formulas in worksheet?

[yog]

Hi,
Can you please tell me what formulas to write in Excel2000 for a yes /no decision based on the following in a pricing worksheet?. This pricing sheet is the place for the user to select the car they would like to purchase and their desired option. Eg. in Y? column, put a Y(yes) for chassis type and put Y in the relevant options sections, will produce (base car price + gadgets + safety + luxury options total price in another area of worksheet).
Vehicle Cost
Chassis type Key:
Sedan $24,990 S: Standard Feature
Deluxe $32,990 O: Optional Feature
Wagon $27,990 N: Not Available
Coupe $35,990 C: No Cost Option

Options Summary

Option Price Sedan Deluxe Wagon Coupe
gadgets
CD Player $100 O S O S
CD Changer $400 O O O O
Navigation $600 O O O O
safety
ABS Brakes $800 O S S S
Traction Control $400 N S O S
Side Airbags $900 O S O S
luxury
Cruise Control $150 O S O S
Automatic Tr. $2,000 O S O O
Metallic Paint $300 O C O C
Leather Interior $1,500 O O N S

1. Price column of options populate with availability and cost of each option
2. If no chassis selected or if more than 1 type selected, price field of all options read “car”
3. Optional feature in currency form, “standard” in grey, “no cost” in green, and “n/a” in red.

Please help!

 

[Thorin]

Assuming that all your amounts are in column C and that all your Yes answers are in column D, the following will do what you want :-

=SUMIF(D:D,"Y",C:C)