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.

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.

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.

I am assuming you have 20 cells with DV and you click on each one in succesion
to enter a number.

Assuming also they are in A1:A20

You now have 20 cells with numbers and you want to SUM them.

Enter =SUM(range) in A21.

Do you get the sum of those 20 cells or just 0?

Where does the list of numbers for the DV cells come from?

A list on same sheet or did you type them into the DV source dialog box?

If from a list, the list of numbers may be text and not real numbers.

You have to force these to be rea; numbers.

That's where the Copy a blank cell..select the list of numbers and Paste
Special(in place)AddOKEsc part comes in.


Gord

On Thu, 8 Dec 2005 07:56:01 -0800, "tp" wrote:

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.