Excel Index Match Date range and return SUM of matches
<p>I have dug around the existing posts but can't find my specific issue so wanted to ask the question. I have a basic spreadsheet at the moment for keeping track of financial information like daily expenses, i want to do more graphs and a summary of spends for weeks and months but have issues with what i am trying to achieve. In essence i want to match the information that includes a month i want to match, for example "/11/2016" and return the SUM of all these matches in another cell (I4 in my example). So far i have this but know i am doing something wrong. The cells are set to DD/MM/YYYY format but i always get the #N/A error.</p>

<p>Any help would be appreciated. Sample is in A3:D5 below:</p>

<p>Date    Amount  Payment From    Payment Method
28/11/2016  24,000  Car sale money less 1000 deposit paid   CASH
22/11/2016  1,000   Deposit for car purchase    CASH</p>

<p>My code at present in I4 is:
=INDEX($B$4:$B$6,MATCH("/11/2016",$A$4:$A$6,0))</p>

<p>I realize i am missing the SUM part and as you can tell i am a novice.</p>

<p>Any help would be much appreciated.</p>

<p>Greetings from Hong Kong</p>