Hello,

I have a very simple table with three columns: Settlement (dates of settlement of purchase and sale of shares), Buy (number of shares bought), Sell (number of shares sold). The first column contains the dates 01/01/2012 through 31/01/2012.

Outside the table I have two fields, say A5 and A6. In A6 I have made a drop down list using the data validation function of the dates from column settlement. Now, in A5 I want to have the sum of all purchases until any given date of the month. So I have tried this formula:

=sumif(Table1[settlement],<=A6,Table1[buy])

This is not accepted by Excel, so I enclosed <=A6 with " ", however I guess that turns it into a string, which of course returns 0.

Could you please help me with this formula. Thank you.