Carley
New Member
Good Afternoon
I have a worksheet which contains telephony information
At present I have three tabs and then a summary tab.
One tab for 2011, one for 2012 and one for 2013
I have a formula for each year which the team leaders can enter a start and end date and get the telephony information back
For 2013 =SUMPRODUCT(--('2013 Data'!$A$4:$A$275>=$E$6)*('2013 Data'!$A$4:$A$275<=$F$6)*('2013 Data'!$B$4:$B$275))
For 2012 =SUMPRODUCT(--('2012 Data'!$A$4:$A$277>=$L$6)*('2012 Data'!$A$4:$A$277<=$M$6)*('2012 Data'!B4:B277))
Now the team leaders would like a formula in which they can look at all three years,
I have tried a couple of formulas that I found on this forum but they don't like the >= or <= when looking at the date these are:
=SUMPRODUCT(SUMIF(INDIRECT("'"&tabs&"'!$A$4:$A$277"),<=e6,INDIRECT("'"&tabs&"'!$A$4:$A$277"),<=f6),INDIRECT("'"&tabs&"'!$B$4:$B$277"))
and
=SUMPRODUCT((THREED('2012 Data':'2013 Data'!$A$4:$A$277<=e6)*(THREED('2012 Data':'2013 Data'!$A$4:$A$277>=f6)*(THREED('2012 Data':'2013 Data'! $B$4:$B$277)))
Can anyone help please?
I have a worksheet which contains telephony information
At present I have three tabs and then a summary tab.
One tab for 2011, one for 2012 and one for 2013
I have a formula for each year which the team leaders can enter a start and end date and get the telephony information back
For 2013 =SUMPRODUCT(--('2013 Data'!$A$4:$A$275>=$E$6)*('2013 Data'!$A$4:$A$275<=$F$6)*('2013 Data'!$B$4:$B$275))
For 2012 =SUMPRODUCT(--('2012 Data'!$A$4:$A$277>=$L$6)*('2012 Data'!$A$4:$A$277<=$M$6)*('2012 Data'!B4:B277))
Now the team leaders would like a formula in which they can look at all three years,
I have tried a couple of formulas that I found on this forum but they don't like the >= or <= when looking at the date these are:
=SUMPRODUCT(SUMIF(INDIRECT("'"&tabs&"'!$A$4:$A$277"),<=e6,INDIRECT("'"&tabs&"'!$A$4:$A$277"),<=f6),INDIRECT("'"&tabs&"'!$B$4:$B$277"))
and
=SUMPRODUCT((THREED('2012 Data':'2013 Data'!$A$4:$A$277<=e6)*(THREED('2012 Data':'2013 Data'!$A$4:$A$277>=f6)*(THREED('2012 Data':'2013 Data'! $B$4:$B$277)))
Can anyone help please?