I Need An Excel Function.?

Question

I need a function that will multiply the (Row x, Column x) by (Row X, Column Y) and Post results in (Row X, Column Z). But I need to replicate it for all rows without changing the code. Maybe Something like (=Product ((Whatever Row, Column x), (Whatever Row, Column Y)) THe rows change every time, but the columns will always be the same. THanks!

Answer 1

This sounds like the SumProduct function. But I am not exactly sure. Do you know about using the $ for when you do not want a row or column to change?

For example $A5 will change the 5 when the function is copied but the A will stay the same no mater where it is copied. Similarly A$5 will keep the 5 constant. and you can even do $A$5 to keep the entire reference constant.