Sumif function

[Todd]

What I have is 2 worksheets. On Sheet 1 there are a
series of dates that can be the same in cell A1:A... In
cell B1:B... there is a number that goes with the date.
On sheet 2 I have a date box that a date can be entered in
cell A1 and would like to have a function that sums the
numbers in B1:b... on sheet 1 into B1 on sheet 2 if the
date matches what is in cell A1 on sheet 1. I am not sure
if sumif is even the route to take. Thanks for the help.

Todd

 

[Peo Sjoblom]

If you are only comparing 2 dates, one in Sheet2 A1 and one in Sheet1 A1

=IF(AND(ISNUMBER(A1),A1='Sheet1'!A1), SUM(B1:B50),"")

if you meant that you want to sum all adjacent values in B if the dates in A
that equal
Sheet2 A1