title: Google Spreadsheet Formula to Use Current Row in Function
body: <p>I want to calculate the product of two different columns (e.g., A &amp; B) for each row on my spreadsheet. For a single row, this would work by using <code>=PRODUCT(A1:B1)</code>, but I can't figure out how to get the function to use the current row instead of a manually entered row. I know you can get a reference to the current row using <code>ROW()</code>, but I get an error when I try something like <code>PRODUCT(AROW():BROW())</code>.</p>