New Excel Forum

This forum has been moved to

Ask all future questions in the New Excel Forum.


Non consecutive cells averaging

Formulas, Functions, Formatting, Charts, Data Analysis, etc.

Non consecutive cells averaging

Postby rossindelicato » Fri Mar 31, 2017 6:12 am

I want to average 3 non-consecutive cells that are populated due to a link from another worksheet. One of the 3 cells may have a #div/0! value and therefore the average calculation results in a #Div/0! I have tried average, averageif & averageifs. Need help

Ross indelicato
  • 0

Posts: 8
Joined: Apr 11, 2012
Location: Subaru of Indiana Automotive
Reputation: 0
Excel Version: 2010

Re: Non consecutive cells averaging

Postby Shashank » Sat Apr 29, 2017 1:35 pm

Please note my proposal for the cell where you are getting #DIV/0!,
please use =IFERROR(A2/A3,0), this will result in 0, therefore your average function will work perfectly

  • 0

Experience is what you get when you don’t get what you want.
Valued Contributor
Posts: 126
Joined: Jul 29, 2013
Location: India
Reputation: 10
Excel Version: 2007

Return to General Excel Questions

Who is online

Users browsing this forum: Google [Bot] and 4 guests