hi
need help here. I need to sum the product of sales and retention. For year 1, I would use sumproduct(a2:a3,b2:b3),
for year 2, I would use sumproduct(a2:a3,b2:b3,b2:b3) but now I need to sum it to the nth year in a formula and seem to figure it out. is it possible to raise b2:b3 to a...