Is there any way to have SUMPRODUCT have a "multi-area selection" for one of its arguments?

[TomCon]

I want a SUMPRODUCT like this:
=SUMPRODUCT(A1:A5,[something])
The [something] would be a selection of 5 cells (to match A1:A5 in length), say the cells i want are: B1, B3, B5, B7, B9.
Is it possible? Cannot find a way to do it.

Thanks!

 

[Fluff]

How about

=SUMPRODUCT(A1:A5,CHOOSE(SEQUENCE(5),B1,B3,B5,B7,B9))

 

[TomCon]

Yes! Thanks very much. Great to see what clever solutions people can offer! Hope i can learn from it, too!

 

[Peter_SSs]

If your ranges happened to be much larger, this one would be more readily expandable as you don't have to individually list the column B cells.

=SUMPRODUCT(A1:A5,FILTER(B1:B9,MOD(ROW(B1:B9)-ROW(B1),2)=0))

 

[Fluff]

Glad to help & thanks for the feedback.