Based on the user input, the estimator will spit out total amount of hours needed to complete the project.

For example; One of the questions is "DB Type". The two possible drop-down options are SQL or Paradox. If the user selects SQL, that's 8 hours of profesional services. If the user selects Paradox, that's worth 4 hours.

If it's a "Centralized Install" that's 8 hours, if it's "De-Centralized" that's 16 hours. etc.

I have about 10-15 questions like this in the entire worksheet.

I need to know how to assign 8 hrs for the SQL selection, and 4 hours for the Paradox selection. Or 8 hrs to the "Centralized" and 16 hours to "De-Centralized"

At the bottom of the worksheet, I will have a cell that will display TOTAL amount of hours needed for the project based on all of the entries.

Any help would be greatly appreciated.

Thanks in advance.