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!
| #VALUE! | |
| 5 | $1.00 |
| 5 | |
| 10 | $0.20 |
| 10 |
2 Replies
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!
