vegaaltair
New Member
- Joined
- Sep 12, 2014
- Messages
- 8
Hello,
I have an issue in getting excel to sum a range beginning at Jan-17 up to and including the current month that will auto update ongoing e.g. next month it will include Jan17-Mar17. I can only seem to have it sum just Jan-17 is it best to use sumifs or sumproduct? Will the formatting of row 1 matter as these are calculated using Edate formula and formatted to mmm-yy
Any help would be greatly appreciated
I have an issue in getting excel to sum a range beginning at Jan-17 up to and including the current month that will auto update ongoing e.g. next month it will include Jan17-Mar17. I can only seem to have it sum just Jan-17 is it best to use sumifs or sumproduct? Will the formatting of row 1 matter as these are calculated using Edate formula and formatted to mmm-yy
Any help would be greatly appreciated