T
Todd
I have two worksheets. On sheet 1 in column A there are a
series of dates, the same and different. In column B
there are numbers that correspond to the dates in A. On
sheet 2 there is a place to input a date for example
11/21/03 in A1. In B1 I would like a formula that would
look in sheet 1 at column A, determine if the date entered
in sheet 2 A1 is there, then sum all of the cells in
column B that correspond to the dates in A1.
series of dates, the same and different. In column B
there are numbers that correspond to the dates in A. On
sheet 2 there is a place to input a date for example
11/21/03 in A1. In B1 I would like a formula that would
look in sheet 1 at column A, determine if the date entered
in sheet 2 A1 is there, then sum all of the cells in
column B that correspond to the dates in A1.