Forum Discussion
winterhalter865
Oct 09, 2024Copper Contributor
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!
#VALUE! | |
5 | $1.00 |
5 | |
10 | $0.20 |
10 |
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)))
- winterhalter865Copper ContributorAwesome! And much obliged!