Hello, I am trying to sum some cells that are using a validation list that I
created. There are about 20 cells that have different numbers that have been
slected from a validaation list and are different. I want to sum these
numbers, but when I do the =SUM function it just comes up with zero. Can you
tell me how to correct this?

Also, I am building a spreadsheet which requires dates to be entered. Is
there a way to have a calendar pop up that you can select adn it will put the
selected date in the cell?

Thank you for your help.