Calculating YTD average from multiple sheets

Utahman

New Member
Joined
Dec 3, 2009
Messages
2
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!
 

Some videos you may like

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

usenethelp

New Member
Joined
Dec 3, 2009
Messages
33
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

New Member
Joined
Dec 3, 2009
Messages
2
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

New Member
Joined
Dec 3, 2009
Messages
33
You cannot ignore the 0's across sheets, but you can do a sum and divide it by month(now()). Would that work?
 

Watch MrExcel Video

Forum statistics

Threads
1,118,167
Messages
5,570,598
Members
412,330
Latest member
carlosjw
Top