*Hi Shine,*

Slight modifications in the method suggest by Satti,

Enter following in cell A3
"" (blank)
Enter following in Cell A4
 =A1*OFFSET(A1,0,1)

Now select the range A3:A4 and drag them to the right side as per your need.

Now apply the following formula to get the answer:-
=sum(3:3)

Note: Sheet is also attached for your reference

Thanks & Best Regards,
-- 
DILIP KUMAR PANDEY
  MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062


On Thu, Apr 30, 2009 at 3:34 PM, Satti Charvak <sat...@gmail.com> wrote:

> I'll give a good clerical answer- we'll if it's not required everyday.
>
> Procedure:
> 1. in cell a2 write =A1*B1 and in cell c2 write =1*D1
> 2. select cells a2 till d2
> 3. Now point the mouse on the lower-right part of d2 cell (you will get a
> black + mouse pointer)
> 4. Now drag the formula to the right and drop it in the last cell you want.
> 5. Now put the formula =sum(2:2) anywhere and you will get the sum.
>
> do you still need a formula or a macro.
> 2009/4/29 ҉Shine <shin...@gmail.com>
>
>> Dear All,
>> Could any one suggest an excel worksheet formula for calculating sum of 
>> adjecent
>> pair of Cells in a Row.
>>
>> For Eg:
>>
>> =(A1*B1)+(C1*D1)+(E1*F1)+.......
>>
>> Conditions
>> Result is towards the right end of the numbers
>> Pairs of columns will be added in-between randomly at later stage.
>>
>> I have been trying with "Sumproduct" function with "mod" to identify
>> adjacent cells. But so far could not figure it out.
>>
>> Does any one have a solution which is not a macro?
>>
>> Thanks in advance
>> Shine
>>
>>
>>
>>
>
>
> --
>
> Thanks and regards,
> Satti Charvak
> ____________________
>
> >
>

--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---

Attachment: for Shine.xls
Description: MS-Excel spreadsheet

Reply via email to