I have an array formula below that adds transactions for each week. This works OK until I come to a week1 which starts on 30 December 2013 and ends 5 January 2014. My work sheets spans more than 1 year, 2013-2015. The answer that I get takes only the transactions in 2014 ie week 1, 1-5 January 2014 and week 1 which starts 29 December 2014 and ends 31 December 2014. How can get the formula to take week 1 being the last part of December 2013 and the first part of January 2014?
=
<tbody>
</tbody>
j12= 05/01/14
Thanks for your help!
=
SUM(((NominalCodes=$D129)+(WeekNumberTB=(J$11))=2)*NetAmount*(CalendarYear=YEAR(J$12))) |
<tbody>
</tbody>
j12= 05/01/14
Thanks for your help!