Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Accurately Calculating YTD Average in Excel?

Status
Not open for further replies.
ETCS

ETCS

Technical User
Jul 21, 2008
38
US
I have an Excel spreadsheet that is being used to graph an average Year To Date value based on 12 individual monthly values. Obviously, as you move through the year there will be later monthly values that are zero because you don't yet have data for them. This causes the AVERAGE formula to be inaccurate because it is including the zero values. What I need is for the formula to only evaluate the values that are greater than zero to accurately represent the YTD average. Any thoughts?

Thanks!
 
Sort by date Sort by votes
Please disregard the post. I was able to determine the appropriate method.

Thanks!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Swi
  • Question
Excel Webservice
Replies
2
Views
207
mintjulep
M
BugZap13
  • Question
Excel formula to count occurrences of a value in a different sheet
Replies
5
Views
496
bs6600
bs6600
renigar
  • Locked
  • Question
Having trouble with Excel Lookup
Replies
5
Views
545
renigar
renigar
Bijugate
  • Locked
  • Question
Excel update question
Replies
0
Views
478
Bijugate
Bijugate
ladyck3
  • Locked
  • Question
Excel 365 - Working with Tables - Calculating data from one worksheet to another. 2
2
Replies
30
Views
642
combo
combo

Part and Inventory Search

Sponsor

Back
Top