average for year

G

Guest

Hi wizards

I have a workbook with sheets for each month. The 13th sheet is for the
year totals. I would like to average the totals for the months on a rolling
basis. for example add jan,feb,march etc then divide by the number of
months. I have tried =sum(jan!e18:dec!e18)/counta(jan!e18:dec!e18) which
divides by 12 but if it is only august then I need it to divide by 9. Also
when I put the range in as an array it won't work as the cells I am taking my
info from contain a formula and unticking "show zeros" has no effect.

Hope you can help
 
B

Bernard Liengme

No time to test but try
=SUM(jan:dec!E18)/COUNT(jan:dec!E18)

Would help to know what is in E18 - number or formula?

Please specify what you mean by array - do you mean just a range of cells?
best wishes
 

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

Similar Threads

Create a 12 month rolling average 15
Average 2
Rolling average 2
Block copy/insert of 5 rows, then update formula below? 2
Average formula only works partially..... 6
Last YTD average in columns with full year of data. 6
Rolling Monthly Average 5
forecast a financial value at year end 1

Top