RE: $$Excel-Macros$$ Need a help on sumproduct for MTD data

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

Re: $$Excel-Macros$$ Need a help on sumproduct for MTD data

=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

$$Excel-Macros$$ Cell value distribution formula

-- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, F

$$Excel-Macros$$ Problemi di sincronizzazione una macro

Salve a tutti! Non riesco proprio a cavarci le gambe...Quando si usa il comando 'SHELL' per eseguire una funzione esterna di sistema, come si può sapere se questo comando ha avuto buon esito oppure se ci sono stati errori? Io sto provando ad effettuare un upload da Excel mediante il comando: S

$$Excel-Macros$$ Need a help on sumproduct for MTD data

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(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @