I am trying to use the SUMIFS function for the first time in Excel 2013.



=SUMIFS(Sheet1!D3:D10,Sheet1!F3:F10,"=>Sheet2!B3",Sheet1!G3:G10,"<Sheet2!C3")




SUMIFS.png




Sum_range - This currently has 2 figures in, £75 and £7152. It associates to monthly income.

Criteria_range1 - This is the start date as to when the monthly income starts. It has 2 dates 01/05/2013 & 13/09/2013

Criteria1 - This points at a cell with the date 01/05/2013

Criteria_range2 - This is the date when the monthly income ends. It has 2 dates in so far, 01/05/2010 & 14/09/2013.




I would expect that in May 2013 it would calculate £75 and in September 2013 £75 + £7152. I have played around with the syntax but the result always ends in £0.00. What am I doing wrong?




Thank you in advance for your help.