Google Spreadsheet Formula to Use Current Row in Function -


i want calculate product of 2 different columns (e.g., & b) each row on spreadsheet. single row, work using =product(a1:b1), can't figure out how function use current row instead of manually entered row. know can reference current row using row(), error when try product(arow():brow()).

if copy formula quoted row, or fill down using ctrl+d, automatically change reference row copying/filling to. called "relative reference". if use formula =product($a$1:$b$1), called "absolute reference", not change if copied elsewhere.

you can use following formula in row:

=a:a*b:b

which return product of 2 values in row formula invoked.


Comments

Popular posts from this blog

javascript - Unusual behaviour when drawing lots of images onto a large canvas -

how can i manage url using .htaccess in php? -

ios - I get the error Property '...' not found on object of type '...' -