Microsoft Excel 2003

[tp]

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.

[Gord Dibben]

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 Special>Add>OK>Esc

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" <[email protected]> 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.

[tp]

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 Special>Add>OK>Esc? 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 Special>Add>OK>Esc
>
> 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" <[email protected]> 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.
>

[Gord Dibben]

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)>Add>OK>Esc part comes in.


Gord

On Thu, 8 Dec 2005 07:56:01 -0800, "tp" <[email protected]> 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 Special>Add>OK>Esc? 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 Special>Add>OK>Esc
>>
>> 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" <[email protected]> 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.
>>