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

2012-08-07 Thread LAKSHMAN PRASAD
C the attached file. ? u r missing. From: Kuldeep Singh naukrikuld...@gmail.com 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

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

2012-08-07 Thread Kuldeep Singh
-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 your formula is not working. It's working fine. =SUMPRODUCT((A7:A24=E1)*(A7:A24=F1)*(F7:F24)) Regards

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

2012-08-07 Thread LAKSHMAN PRASAD
ok From: LAKSHMAN PRASAD lakshman_...@yahoo.com To: excel-macros@googlegroups.com 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 r

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

2012-08-06 Thread LAKSHMAN PRASAD
You are missing  SUMPRODUCT((A7:A23E1)*(A7:A23F1)*(F7:F23))   Lakshman Prasad Manager (Finance) GAURSONS INDIA LIMITED Ph: +91 12 456777 Mob. No. 9582279261 Website: http://www.gaursonsindia.com/ From: Ashish Bhalara ashishbhalar...@gmail.com To:

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

2012-08-06 Thread Ashish Bhalara
Thanks to all, I make very silly mistake. On Mon, Aug 6, 2012 at 12:29 PM, LAKSHMAN PRASAD lakshman_...@yahoo.comwrote: You are missing SUMPRODUCT((A7:A23E1)*(A7:A23F1)*(F7:F23)) *Lakshman Prasad* Manager (Finance) GAURSONS INDIA LIMITED Ph: +91 12 456777 Mob. No. 9582279261 Website:

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

2012-08-04 Thread Rajan_Verma
=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$$

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

2012-08-04 Thread Kuldeep Singh
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