Re: $$Excel-Macros$$ How to ADD product of two columns in a single cell

=sumproduct(R1:R3,C1:C3) On Mon, Jul 26, 2010 at 1:18 PM, SUMIT VYAS wrote: > good > > On Thu, Jul 22, 2010 at 10:27 PM, Harmeet Singh > wrote: > >> Hi There, >> >> See attached file. >> >> >> >> Warm Regards, >> >> Harmeet Singh >> IT Analyst >> McKinsey & Company >> http://www.facebook.co

Re: $$Excel-Macros$$ How to ADD product of two columns in a single cell

good On Thu, Jul 22, 2010 at 10:27 PM, Harmeet Singh wrote: > Hi There, > > See attached file. > > > > Warm Regards, > > Harmeet Singh > IT Analyst > McKinsey & Company > http://www.facebook.com/Harmeeet > > > On Thu, Jul 22, 2010 at 11:42 AM, Rave Patwal wrote: > >> Please help to add the produ

Re: $$Excel-Macros$$ How to ADD product of two columns in a single cell

Hi There, See attached file. Warm Regards, Harmeet Singh IT Analyst McKinsey & Company http://www.facebook.com/Harmeeet On Thu, Jul 22, 2010 at 11:42 AM, Rave Patwal wrote: > Please help to add the product of two columns e.g. > > Column1Column2 > > 23 119 > 89

Re: $$Excel-Macros$$ How to ADD product of two columns in a single cell

Use =SUMPRODUCT(A1:A3,B1:B3) Assuming Column 1 is A and Column 2 is B Cheers Andy On Thu, Jul 22, 2010 at 11:42 AM, Rave Patwal wrote: > Please help to add the product of two columns e.g. > > Column1Column2 > > 23 119 > 8954 > 63 32 > >

Re: $$Excel-Macros$$ How to ADD product of two columns in a single cell

Hi Mr. Patwal, Try using SumProduct funtion to achieve desired results...!! SumProduct((First Column Reference),(Second Column Reference)) -- Thanks & Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India O

$$Excel-Macros$$ How to ADD product of two columns in a single cell

Please help to add the product of two columns e.g. Column1Column2 23 119 8954 63 32 Want to add (r1c1*r1c2+r2c1*r2c2+r3c1*r3c2) Thanks Ravi -- -- So