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
[TABLE="class: grid, width: 793"]
<colgroup><col><col span="9"><col></colgroup><tbody>[TR]
[TD] [/TD]
[TD="colspan: 9"]Sent[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Who[/TD]
[TD="align: right"]Apr-14[/TD]
[TD="align: right"]May-14[/TD]
[TD="align: right"]Jun-14[/TD]
[TD="align: right"]Jul-14[/TD]
[TD="align: right"]Aug-14[/TD]
[TD="align: right"]Sep-14[/TD]
[TD="align: right"]Oct-14[/TD]
[TD="align: right"]Nov-14[/TD]
[TD="align: right"]Dec-14[/TD]
[TD]SignUp Date[/TD]
[/TR]
[TR]
[TD]a[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]Aug-13[/TD]
[/TR]
[TR]
[TD]b[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]765[/TD]
[TD="align: right"]766[/TD]
[TD="align: right"]767[/TD]
[TD="align: right"]768[/TD]
[TD="align: right"]769[/TD]
[TD="align: right"]770[/TD]
[TD="align: right"]Sep-13[/TD]
[/TR]
[TR]
[TD]c[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]Oct-13[/TD]
[/TR]
[TR]
[TD]d[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]543[/TD]
[TD="align: right"]544[/TD]
[TD="align: right"]545[/TD]
[TD="align: right"]546[/TD]
[TD="align: right"]547[/TD]
[TD="align: right"]548[/TD]
[TD="align: right"]549[/TD]
[TD="align: right"]550[/TD]
[TD="align: right"]Nov-13[/TD]
[/TR]
[TR]
[TD]e[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]Dec-13[/TD]
[/TR]
[TR]
[TD]f[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]654[/TD]
[TD="align: right"]655[/TD]
[TD="align: right"]656[/TD]
[TD="align: right"]657[/TD]
[TD="align: right"]658[/TD]
[TD="align: right"]659[/TD]
[TD="align: right"]660[/TD]
[TD="align: right"]Oct-13[/TD]
[/TR]
[TR]
[TD]g[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]Oct-13[/TD]
[/TR]
[TR]
[TD]h[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]54[/TD]
[TD="align: right"]55[/TD]
[TD="align: right"]56[/TD]
[TD="align: right"]57[/TD]
[TD="align: right"]58[/TD]
[TD="align: right"]59[/TD]
[TD="align: right"]60[/TD]
[TD="align: right"]Mar-14[/TD]
[/TR]
[TR]
[TD]i[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]Oct-13[/TD]
[/TR]
[TR]
[TD]j[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]Aug-13[/TD]
[/TR]
[TR]
[TD]fd[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]34[/TD]
[TD="align: right"]35[/TD]
[TD="align: right"]36[/TD]
[TD="align: right"]37[/TD]
[TD="align: right"]38[/TD]
[TD="align: right"]39[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]41[/TD]
[TD="align: right"]Aug-13[/TD]
[/TR]
[TR]
[TD]fd[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]Aug-13[/TD]
[/TR]
</tbody>[/TABLE]
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
[TABLE="class: grid, width: 793"]
<colgroup><col><col span="9"><col></colgroup><tbody>[TR]
[TD] [/TD]
[TD="colspan: 9"]Sent[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Who[/TD]
[TD="align: right"]Apr-14[/TD]
[TD="align: right"]May-14[/TD]
[TD="align: right"]Jun-14[/TD]
[TD="align: right"]Jul-14[/TD]
[TD="align: right"]Aug-14[/TD]
[TD="align: right"]Sep-14[/TD]
[TD="align: right"]Oct-14[/TD]
[TD="align: right"]Nov-14[/TD]
[TD="align: right"]Dec-14[/TD]
[TD]SignUp Date[/TD]
[/TR]
[TR]
[TD]a[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]Aug-13[/TD]
[/TR]
[TR]
[TD]b[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]765[/TD]
[TD="align: right"]766[/TD]
[TD="align: right"]767[/TD]
[TD="align: right"]768[/TD]
[TD="align: right"]769[/TD]
[TD="align: right"]770[/TD]
[TD="align: right"]Sep-13[/TD]
[/TR]
[TR]
[TD]c[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]Oct-13[/TD]
[/TR]
[TR]
[TD]d[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]543[/TD]
[TD="align: right"]544[/TD]
[TD="align: right"]545[/TD]
[TD="align: right"]546[/TD]
[TD="align: right"]547[/TD]
[TD="align: right"]548[/TD]
[TD="align: right"]549[/TD]
[TD="align: right"]550[/TD]
[TD="align: right"]Nov-13[/TD]
[/TR]
[TR]
[TD]e[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]Dec-13[/TD]
[/TR]
[TR]
[TD]f[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]654[/TD]
[TD="align: right"]655[/TD]
[TD="align: right"]656[/TD]
[TD="align: right"]657[/TD]
[TD="align: right"]658[/TD]
[TD="align: right"]659[/TD]
[TD="align: right"]660[/TD]
[TD="align: right"]Oct-13[/TD]
[/TR]
[TR]
[TD]g[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]Oct-13[/TD]
[/TR]
[TR]
[TD]h[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]54[/TD]
[TD="align: right"]55[/TD]
[TD="align: right"]56[/TD]
[TD="align: right"]57[/TD]
[TD="align: right"]58[/TD]
[TD="align: right"]59[/TD]
[TD="align: right"]60[/TD]
[TD="align: right"]Mar-14[/TD]
[/TR]
[TR]
[TD]i[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]Oct-13[/TD]
[/TR]
[TR]
[TD]j[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]Aug-13[/TD]
[/TR]
[TR]
[TD]fd[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]34[/TD]
[TD="align: right"]35[/TD]
[TD="align: right"]36[/TD]
[TD="align: right"]37[/TD]
[TD="align: right"]38[/TD]
[TD="align: right"]39[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]41[/TD]
[TD="align: right"]Aug-13[/TD]
[/TR]
[TR]
[TD]fd[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]Aug-13[/TD]
[/TR]
</tbody>[/TABLE]
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