Afternoon all,

Need some help with excel formulae in adding a series of values with corresponding dates that meet a certain criteria.

Before I show what I have currently, to put in context. There are a list of dates in column H and a balance for each of these in column L. What I am trying to do is to sum the values in column L for a given month and week but not running over into past months (i.e February).

=SUMIFS($L$2:$L$100,($H$2:$H$100=(">="&Q1-7)),$L$2:$L$100,($H$2:$H$100=(">="&1/3/2016)))

Q1 being today's date

I'm trying to use the above to calculate all the values in L that have a date in H within the last week but are "not" before the 01/03/2016

I also want to try and repeat the above for values of L that are only in the month of March in total.

Any help would be much appreciated

Regards