Confidentjohn
Board Regular
- Joined
- Mar 3, 2009
- Messages
- 73
Hi
I am trying to see if it is possible to do a sumifs across an array of data
my data looks like
<colgroup><col><col span="9"><col></colgroup><tbody>
</tbody>
I want to find the total number of sends in Jun 14 for people who signed up in Oct 13
The answer should be 679,
Ive tried a sumproduct and a sumifs across the range but can't get it to work
Could anyone help me out please
Cheers
John
I am trying to see if it is possible to do a sumifs across an array of data
my data looks like
Sent | ||||||||||
Who | Apr-14 | May-14 | Jun-14 | Jul-14 | Aug-14 | Sep-14 | Oct-14 | Nov-14 | Dec-14 | SignUp Date |
a | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | Aug-13 |
b | 2 | 3 | 4 | 765 | 766 | 767 | 768 | 769 | 770 | Sep-13 |
c | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | Oct-13 |
d | 4 | 543 | 544 | 545 | 546 | 547 | 548 | 549 | 550 | Nov-13 |
e | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | Dec-13 |
f | 6 | 7 | 654 | 655 | 656 | 657 | 658 | 659 | 660 | Oct-13 |
g | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | Oct-13 |
h | 8 | 9 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | Mar-14 |
i | 9 | 10 | 11 | 12 | 13 | 5 | 6 | 7 | 8 | Oct-13 |
j | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | Aug-13 |
fd | 11 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | Aug-13 |
fd | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | Aug-13 |
<colgroup><col><col span="9"><col></colgroup><tbody>
</tbody>
I want to find the total number of sends in Jun 14 for people who signed up in Oct 13
The answer should be 679,
Ive tried a sumproduct and a sumifs across the range but can't get it to work
Could anyone help me out please
Cheers
John