joseway1979
New Member
- Joined
- Nov 10, 2014
- Messages
- 11
Hi,
I was wondering if there was an easier way of adding between 2 date ranges. At the moment I am using the sumifs function, but this only works to add up from 1 column and what i need to do is sum up from about 10 column between a date range, see example below;
A B C D E F G H I J K
01/01/2016 1 1 1 1 1 1 1 1 2 2
02/01/2016 1 1 1 1 1 1 1 1 2 2
02/01/2016 1 1 1 1 1 1 1 1 2 2
02/01/2016 1 1 1 1 1 1 1 1 2 2
05/01/2016 1 1 1 1 1 1 1 1 2 2
06/01/2016 1 1 1 1 1 1 1 1 2 2
07/01/2016 1 1 1 1 1 1 1 1 2 2
So, currently, I can only sum between date ranges for say column B, when really what I want to do is sum from columns B to K between a date range.
Any help is much appreciated.
I was wondering if there was an easier way of adding between 2 date ranges. At the moment I am using the sumifs function, but this only works to add up from 1 column and what i need to do is sum up from about 10 column between a date range, see example below;
A B C D E F G H I J K
01/01/2016 1 1 1 1 1 1 1 1 2 2
02/01/2016 1 1 1 1 1 1 1 1 2 2
02/01/2016 1 1 1 1 1 1 1 1 2 2
02/01/2016 1 1 1 1 1 1 1 1 2 2
05/01/2016 1 1 1 1 1 1 1 1 2 2
06/01/2016 1 1 1 1 1 1 1 1 2 2
07/01/2016 1 1 1 1 1 1 1 1 2 2
So, currently, I can only sum between date ranges for say column B, when really what I want to do is sum from columns B to K between a date range.
Any help is much appreciated.
