+ Reply to Thread
Results 1 to 3 of 3

AVERAGEIF returning #DIV/0!

Hybrid View

  1. 02-03-2010, 01:25 PM #1
    Cassi
    Cassi is offline
    Registered User
    Join Date
    01-20-2010
    Location
    Raleigh, NC
    MS-Off Ver
    Excel 2010
    Posts
    21

    Thumbs up AVERAGEIF returning #DIV/0!

    I am using the following formula, but for the cells that dont have data I get the #DIV/0! error.

    =AVERAGEIF($B$6:$B$48,B59,$W$6:$W$48)

    Help please!
    Last edited by Cassi; 02-03-2010 at 01:41 PM.
    Reply With QuoteRegister To Reply
  2. 02-03-2010, 01:37 PM #2
    Ron Coderre
    Ron Coderre is offline
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: AVERAGEIF returning #DIV/0!

    Try this:
    =IFERROR(AVERAGEIF($B$6:$B$48,B59,$W$6:$W$48),"no match")
    Does that help?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules
    Reply With QuoteRegister To Reply
  3. 02-03-2010, 01:40 PM #3
    Cassi
    Cassi is offline
    Registered User
    Join Date
    01-20-2010
    Location
    Raleigh, NC
    MS-Off Ver
    Excel 2010
    Posts
    21

    Smile Re: AVERAGEIF returning #DIV/0!

    Perfect! Thanks
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1