Home » questions » I Need An Excel Function.?

I Need An Excel Function.?

1
2006-08-06 13:33:19, Category: Programming & Design
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!

Answers

  1. rscanner

    On 2006-08-06 14:02:57


    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.