# Calculating YTD average from multiple sheets

#### Utahman

##### New Member
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!

### 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
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
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
You cannot ignore the 0's across sheets, but you can do a sum and divide it by month(now()). Would that work?

Replies
2
Views
75
Replies
9
Views
232
Replies
21
Views
224
Replies
3
Views
87
Replies
0
Views
77