Let's say for example I have a number in cell A1 and a number in cell B1, and I want to multiply A1 and B1, and take sums of powers of the product.

So, Step 1: A1*B1

Step 2: (A1*B1) + (A1*B1)^2 + (A1*B1)^3 + ... + (A1*B1)^K

I was trying to find a way to use the SUMPRODUCT function, but I'm trying to avoid making individual cells for each A1*B1, (A1*B1)^2, ..., and (A1*B1)^K.

Any thoughts? Thanks guys!