Re: $$Excel-Macros$$ Sumproduct function to get sum between two date

ok From: LAKSHMAN PRASAD To: "excel-macros@googlegroups.com" Sent: Tuesday, August 7, 2012 11:53 AM Subject: Re: $$Excel-Macros$$ Sumproduct function to get sum between two date C the attached file. ? u

Re: $$Excel-Macros$$ Sumproduct function to get sum between two date

egroups.com > *Sent:* Monday, August 6, 2012 12:44 PM > *Subject:* Re: $$Excel-Macros$$ Sumproduct function to get sum between > two date > > > Dear Lakshman, > > Require output value 4625000 your formula is not working. > > It's working fine. =SUMPRODUCT((A7:A24&g

Re: $$Excel-Macros$$ Sumproduct function to get sum between two date

C the attached file. ? u r missing. From: Kuldeep Singh To: excel-macros@googlegroups.com Sent: Monday, August 6, 2012 12:44 PM Subject: Re: $$Excel-Macros$$ Sumproduct function to get sum between two date Dear Lakshman, Require output value 4625000

Re: $$Excel-Macros$$ Sumproduct function to get sum between two date

Dear Lakshman, Require output value 4625000 your formula is not working. It's working fine. =SUMPRODUCT((A7:A24>=E1)*(A7:A24<=F1)*(F7:F24)) Regards, Kuldeep Singh Phone.: +91-120-4763789, Extn.: 789 naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the environment. Please don't print

Re: $$Excel-Macros$$ Sumproduct function to get sum between two date

Thanks to all, I make very silly mistake. On Mon, Aug 6, 2012 at 12:29 PM, LAKSHMAN PRASAD wrote: > You are missing > > > SUMPRODUCT((A7:A23>E1)*(A7:A23 > > *Lakshman Prasad* > Manager (Finance) > GAURSONS INDIA LIMITED > Ph: +91 12 456777 Mob. No. 9582279261 > Website: http://www.gaursonsindia.c

Re: $$Excel-Macros$$ Sumproduct function to get sum between two date

You are missing  SUMPRODUCT((A7:A23>E1)*(A7:A23http://www.gaursonsindia.com/ From: Ashish Bhalara To: excel-macros@googlegroups.com Sent: Saturday, August 4, 2012 4:02 PM Subject: $$Excel-Macros$$ Sumproduct function to get sum between two date Dear expert

Re: $$Excel-Macros$$ Sumproduct function to get sum between two date

Hi Ashish, Please see attachment. Regards, Kuldeep Singh Phone.: +91-120-4763789, Extn.: 789 naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the environment. Please don't print this e-mail unless you really need to.* On Sat, Aug 4, 2012 at 4:19 PM, Rajan_Verma wrote: > *=SUMPRODUCT

RE: $$Excel-Macros$$ Sumproduct function to get sum between two date

=SUMPRODUCT((A7:A23>=E1)*(A7:A23<=F1)*(F7:F23)) Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ashish Bhalara Sent: 04 August 2012 4:02 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Su