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!
=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!