Forum Discussion
Sum product of a range of rows - just not the even rows
I need to have the product of 2 columns in a range of about 100 rows. I don't want to include the odd rows, though. In this example the solution would be 700... what's the proper formula - help! ...
Let's say that the values are in A3:B102 and that they are all numbers or blank (no text values).
=SUM(A3:A102*B3:B102*ISODD(ROW(B3:B102)))
Awesome! And much obliged!