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
Bookmarks