I have tried you suggestion and was unsuccessful only a date 00-01-1900 was
returned from the formula. Am I missing something here?


"Jason Morin" wrote in message
...
Try SUMIF. For example, let's say your dates are in col.
A, values to sum in col. B, and all this is in a sheet
named "mysheet". With a date in A1 of a new sheet, use:

=SUMIF(mysheet!A:A,A1,mysheet!B:B)

HTH
Jason
Atlanta, GA

-----Original Message-----
Can anyone tell me if it is possible to have two or more
columns in a
defined range. I want to have a dropdown validation list
where two or more
columns of data is displayed on the dropdown list. When
an item is selected
in the dropdown list only one of the columns data is
displayed in the cell.
Is this possible and how is this accomplished?
Or if there is a different approach I should go down
please let me know.

Thanks
Pat


.