Multiplying and summing every nth range

[skimp]

Please help!

I'm a newbie to all this and am struggling to write a function that will split a range into two and multiply the corresponding ranges together. I'm sorry the descritpion isn't any better but I don't know how better to explain it. Basically, I have this ugly formula being run at the moment:

Please Login or Register  to view this content.

And attempted to write a new function (that isn't working) that looks like this:

Please Login or Register  to view this content.

Any help would be awesome and if I could provide any further information, just ask.

Thanks!

[Pete_UK]

Your formula looks like the sum of products, so why not use SUMPRODUCT? Something like this:

=SUMPRODUCT((B8:X8)*(C8:Y8)*(MOD(COLUMN(B8:X8),2)=0))

Hope this helps.

Pete

[Teethless mama]

Try this elegant formula:

=SUMPRODUCT(B8:X8,C8:Y8)

[skimp]

I tried that and it gives me this:

B8 -5
C8 -5
D8 -5
E8 -5
F8 -5
G8 -5
H8 -5
I8 - 5

j8 - =SUMPRODUCT(B8:H8,C8:I8) = 175

It's producing "175" when really it should be "100" (5*5+5*5+5*5).

This function is ruining my mental health.....

[skimp]

IT WORKS!!!!!!

Thank you so much for the assistance!

[arlu1201]

Skimp,

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.