Hi team,
any update on this ?
Thanks & Regards,
Ganesh N
On Sat, Apr 12, 2014 at 9:26 PM, Ganesh N wrote:
> Hi Ashish/Team,
>
> I need to do sumproduct for both forecast and AHT (2 type of data). Can
> you please help me on that ?
>
> Thanks & Regards,
> Ganesh N
>
>
> On Fri, Apr 11, 2014 a
Hi Ashish/Team,
I need to do sumproduct for both forecast and AHT (2 type of data). Can you
please help me on that ?
Thanks & Regards,
Ganesh N
On Fri, Apr 11, 2014 at 11:58 PM, ashish koul wrote:
> =SUMPRODUCT(($B$2:$DC$2=B9)*($B$4:$DC$4))
>
>
> On Fri, Apr 11, 2014 at 4:50 PM, Ganesh N wro
Hi Ganesh,
Use the below formula.
For Forecast 1 =SUMPRODUCT((MONTH($B$3:$DC$3)=MONTH(B$10))*$B$4:$DC$4)
For AHT
=SUMPRODUCT((MONTH($B$3:$DC$3)=MONTH(B$10))*$B$5:$DC$5)
Regards,
Excel Beginner
From: excel-macros@googlegroups.com [mailto:excel-macros@googl
=SUMPRODUCT(($B$2:$DC$2=B9)*($B$4:$DC$4))
On Fri, Apr 11, 2014 at 4:50 PM, Ganesh N wrote:
> Hi Team,
>
> Kindly help me out to do sumproduct the data for MTD. (monthwise).
>
> Please find the attachment for your reference.
>
> Thanks & Regards,
> Ganesh N
>
> --
> Are you =EXP(E:RT) or =NOT(EX
