On Dec 6, 11:51*am, Ron Rosenfeld wrote:
On Mon, 6 Dec 2010 02:14:59 -0800 (PST), Stav19





wrote:
Hi All

I'm trying to create a formula to use in a monthly report to calculate
YTD sum for PL, and average for Balance sheet.

For P/L I can use the following:

SUM(AZ28:OFFSET(BL28,0,-(12-$C$2)-1),)

Where C2 is the month number.

However with the following figures:

Jan *Feb *Mar *Apr *May *Jun *Jul * Aug *Sep *Oct *Nov *Dec
487 *450 *405 *428 *492 * 443 *415 550 * 357 * 416 *416 *442

and the formula:
AVERAGE(AZ6:OFFSET(BL6,0,-(12-$C$2)-1),)

Instead of getting an average of 450, I get 405, and I'm struggling to
resolve this.

Can anyone point out what I'm doing wrong?

Cheers
Ins

You need to supply more data.

What is in the other referenced cells than C2.

Which of the posted values above AVERAGE 450? *Using a YTD Averaging
formula, I can't find any combination that does so.- Hide quoted text -

- Show quoted text -

Hi Ron

Apologies, you're right I wasn't very clear, and I typed the wrong
average...For November YTD, the average should be 442, but I was
calculating 405. C2 had the number of months, so was 11 for November.

Thanks