Results 1 to 6 of 6

#DIV/0 Error

Threaded View

  1. #1
    Registered User
    Join Date
    06-23-2009
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2003
    Posts
    7

    #DIV/0 Error

    I'm trying to get rid of the DIV/0 error that keeps popping up with this formula:

    =(SUMIF(B2:B26,"YES",C2:C26))/((COUNTA(C2:C26)))

    I've tried to add the ISERROR function and a couple other functions but I haven't had any luck. Anyone have any suggestions?
    Last edited by Finn; 06-23-2009 at 02:10 PM.

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1