On Mon, 6 Dec 2010 06:06:41 -0800 (PST), Stav19
wrote:

On Dec 6, 1:57*pm, Ron Rosenfeld wrote:
On Mon, 6 Dec 2010 05:45:05 -0800 (PST), Stav19

wrote:
If the reference is say AZ, the first part of the formula I get, "0,0"
means 0 rows and 0 columns, I don't get why the height has to be 1
though? I get the width being the number of months.

"height" = the number of rows to return.
"width" = the number of columns to return

Does your data span more than one row?

If your data spans more than 1 row, adjust the height parameter to
fit, or leave it "empty" in which case it will default to the height
of the original reference.

e.g:

=average(offset(JanCellRef,0,0,,C2))

or even:

=average(offset(JanCellRef,,,,C2))

are all equivalent to the original, if JanCellRef is a single cell.

=average(offset(JanCellRef,0,0,1,C2))

Fantastic, thanks very much Ron, appreciate it!

Glad to help. Thanks for the feedback.