Creating a for loop with an embedded if statement

I would like one sheet to reference another, thats ez. First sheet has credit card statements on it Second sheet needs to look at first sheet and look at the date ranges, for each date it should check to see if it is the date in the A column of the 2nd sheet. If it is the correct date it should add that amount to column B of the 2nd sheet.

So in a real basic coding language it would look like this

B1 = 0
For Sheet1!A1 to Sheet1!A99(If Sheet1!A1 = Sheet2!A1 then Sheet2!B1 + Sheet1!B2)

I just want to know if this is possible in excel or if i'm going to be doing all this by hand, which would make me sad.