Another simplified addition formula needed please

[kishorkhanal]

I want to do the following:

CB11=B11*C8+D11*E8+......+BX11*BY8

Please help!

 

[Jonmo1]

Perhaps

=SUMPRODUCT((B11:BX11*C8:BY8)*(MOD(COLUMN(B11:BX11),2)=0))

 

[Aladin Akyurek]

Perhaps

=SUMPRODUCT((B11:BX11*C8:BY8)*(MOD(COLUMN(B11:BX11),2)=0))

Robustified...

=SUMPRODUCT(
    --(B11:BX11*C8:BY8),
    --(MOD(COLUMN(B11:BX11)-COLUMN(B11),2)=0))

with plugging in

-COLUMN(B11)

 

[kishorkhanal]

I am getting #VALUE error on both of the above formulas.

 

[Aladin Akyurek]

I am getting #VALUE error on both of the above formulas.

I produced there a copy-paste accident while intending to change from the * syntax to the comma syntax...

=SUMPRODUCT(
    B11:BX11,
    C8:BY8,
    --(MOD(COLUMN(B11:BX11)-COLUMN(B11),2)=0))

Does this help?

 

[kishorkhanal]

Thanks a lot. Works great!!

 

[Aladin Akyurek]

Thanks a lot. Works great!!

You are welcome. Thanks for providing feedback.