Sorry - that wasn't my question.

Let me try and rephrase. I'd like to create a formula to calculate the
summation of some function, say f(x), evaluated at values x=A1 through x=A10.
So, the answer would be something like f(A1)+f(A2)+f(A3)...+f(A10).

Ultimately, I'd like to be able to do the same thing for a function
dependent on two variables, say f(x,y), evaluated at x=A1 through x=A10 and
y=B1 through y=B10, which would evaluate to:
f(A1,B1)+f(A2,B2)+f(A3,B3)...+f(A10,B10).

I'd like to avoid copy/paste, because in reality I'll be doing this
summation for large ranges, and I'd like to avoid making a separate
worksheet, because I'll have many different slight variations on this
equation.

Sorry - I'm coming from Mathematica, which does this in a different way, so
my question might be a bit odd... and confusing.

Thank you!

"Spiky" wrote:

I'm not sure what you are asking. Is this just about how to Copy/
Paste?

There are 2 ways to copy/paste to get various results.

-You can highlight a part of a formula in the Formula Bar, and then
copy/paste it in there over and over so you don't have to retype a
repetitive section. But you'll have to manually change the parts that
do change. Like in your example, the B and C references change, so
you'd have to go back and retype those.

-You can set references to absolute and relative as needed, then copy/
paste one cell to another to have different sums for different ranges.