Summing/Multiplying cells across different rows and totalling all the values up

[Vinod Venkat]

Its a bit difficult to explain. So I thought I might provide a sample formula:

Total = ((A1 + B1)*C2)+((A3 + B3)*C4)+((A5 + B5)*C6)

I have 1000 rows to total and entering this formula is cumbersome.

Any formulas to speed this up would be welcome.

 

[shadow12345]

Hi and welcome to the board.


Im not quite sure what your question is, can you not just copy and paste the formula? or do the values you are totaling change?

A sample of the worksheet data would be easiest (the stickies can tell you how to post the data onto the board)

 

[Vinod Venkat]

Hi,

Sorry for not being clear. A1, B1 etc are cells references containing numbers. I have entered the below formula in excel and now need to extend this series all the way to row 1005 as shown below. I can enter the formula in manually but it is very time consuming.

Total = ((A1 + B1)*C2)+((A3 + B3)*C4)+((A5 + B5)*C6)....+((A1005+B1005)*C1006)

Just wanted to know if there is a alternate excel function I could use to get the same result.

Hope this helps.

 

[Aladin Akyurek]

Its a bit difficult to explain. So I thought I might provide a sample formula:

Total = ((A1 + B1)*C2)+((A3 + B3)*C4)+((A5 + B5)*C6)

I have 1000 rows to total and entering this formula is cumbersome.

Any formulas to speed this up would be welcome.

=SUMPRODUCT((A1:A5+B1:B5),(MOD(ROW(C2:C6)-ROW(C2),2)=0)+0,C2:C6)

Adjust the ranges to suit.

 

[Vinod Venkat]

Its worked. You are a champion!! Thanks Aladin.

Thanks Shadow 12345 for your help too.

 

[Aladin Akyurek]

Its worked. You are a champion!! Thanks Aladin.

Thanks Shadow 12345 for your help too.

You are welcome. Thanks for providing feedback.