Hello, thanks for the link to the calendar. I will try that out this
afternoon. As for the SUm of the data validation, I am sorry I do not
follow. Once I select the cell and do the data validation where do I past in
the SpecialAddOKEsc? Then, where do I do my sum formula for the cells
whewre the numbers are?

Thanks for your help.

"Gord Dibben" wrote:

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.