I need a formula that applies a function to the value of each cell in a range and then adds the results. I cannot use an auxiliary column because the function includes a relative reference to another cell, and it will be copied row after row for an indefinite number of rows. In other words, want to be able to write something like “=mysum(x^H2 for x in D2:D17)” in cell K2, “=mysum(x^H3 for x in D2:D17)” in cell K3, etc.
This seems like an obvious thing to me, but I have not found anything in my searches that would allow me to it. Is it really impossible to do this?