Ignore this. I responded to the wrong post. Sorry.

Jason

-----Original 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


.

.