0
74

Honestly I thought It was a waste of my time for me learning the ADDRESS function in Google Sheets. But later I realised the worthiness of this function. I will come to that. First you should learn how to use Address Function in Google Sheets. After learning the use of this formula, we can go to an awesome tutorial using Address formula in Google Doc Spreadsheets. A rare combo that would do wonder with ranges in your formula.

No more suspense. In my leisure, I did some experiment with Google Sheets Address function and found out a way to create Dynamic SUM ranges in Google Sheets, that without any additional column or cell reference! It’s sheer magic! First let us learn the use of Address Function.

Purpose:

The purpose of Address function is to return a cell reference or cell address as text as per the specified row and column numbers and other references.

Syntax:

This time you should give importance to the Syntax part. Here it’s.

It’s a long syntax. I will come to each elements in this syntax with the help of a chart. See the chart below where I’ve used colour patterns to reveal everything about the Address Function Syntax elements.

You can use ROW, COLUMN functions within Address function as below to get the cell address.