Sum odd cell values if even cells are not empty

Question

I have the following data:

4 |   | 1 | 2 |   |   | 2 | 3

I want to sum odd values when the following even cell is not empty. So my sum must be: 1 + 2 = 3

I use this formula:

=SUMPRODUCT((MOD(COLUMN(F2:BE2);2)=0)*F2:BE2)

It obviously gives: 4 + 1 + 2 = 7

How can I change the formula to get the 1st result?

Answer 1

Try this:

=SUMPRODUCT((MOD(COLUMN(E2:BD2);2)=1)*(F2:BE2<>"")*(E2:BD2))