tp

1. If the numbers in the DV lists are "real" numbers, SUM will work.

Perhaps they are text?

Try this.......Copy an empty cell which is formatted as General.

Select the list you are using for DV source and Paste SpecialAddOKEsc

2. Ron de Bruin has a Calendar Control on his site.

http://www.rondebruin.nl/calendar.htm


Gord Dibben Excel MVP

On Wed, 7 Dec 2005 09:33:02 -0800, "tp" wrote:

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.