Calculating YTD average from multiple sheets

[Utahman]

This may be a simple question. How would I run a YTD average across multiple sheets? I have a budget broken down into months with a summary at the end. I can obtain an overall average, but this obviously isn't accurate. Any help would be great!

 

[usenethelp]

What do you have in the future month sheets in that cell? If they are empty then they will not be included in the average. You could use another cell on each sheet with a formula to return either the number you want to average (if the current date is greater or equal to the sheet name) or it will return "". Then your existing average formula should work.

 

[Utahman]

Im drawing the average from dollar values from each sheet, if there isn't an entry, the value is "0." Is there a way I can obtain a ytd average with these values of "0"?

 

[usenethelp]

You cannot ignore the 0's across sheets, but you can do a sum and divide it by month(now()). Would that work?