Making inputs for average formula dynamic


S

Sumaira

Hi All,

I am working on a workbook that requires prior 3 month averag
calculations each month for several rows. So lets say its July right no
and Apr, May, June numbers are in columns A B and C. When I go into Aug
I want the forumla to calculate the average of B, C and D and so on fo
each new month.

Can any one help me with how I can make the inputs dynamic, so I don
have to update it each month. Assistance will be greatly appreciated.

Regards,
Sumair
 
Ad

Advertisements

Z

zvkmpw

I am working on a workbook that requires prior 3 month average
calculations each month for several rows. So lets say its July right now
and Apr, May, June numbers are in columns A B and C. When I go into Aug,
I want the forumla to calculate the average of B, C and D and so on for
each new month.

If the numbers are in row 1 starting at A1, and if there are no gaps, and if future months' cells are empty, then maybe this meets the need:
=IF(COUNTA(1:1)<3,"not enough data",
AVERAGE(OFFSET(A1,0,COUNTA(1:1)-3,1,3)))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top