New Excel Forum

This forum has been moved to TeachExcel.

Ask all future questions in the new excel forum.

ExcelKey

Non consecutive cells averaging

Formulas, Functions, Formatting, Charts, Data Analysis, etc.
Forum rules
This forum is closed.

All new posts should be made at our new Excel Forum at TeachExcel.com.

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

rossindelicato
Rookie
 
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

Sir,
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

Regards
Shashank
  • 0

[b][color=#400040]Shashank[/color][/b]
Experience is what you get when you don’t get what you want.
Shashank
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: No registered users and 1 guest