Results 1 to 6 of 6

Dividing populated cells against unpopulated cells in data set

Threaded View

  1. #4
    Registered User
    Join Date
    01-13-2010
    Location
    ohio
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Dividing populated cells against unpopulated cells in data set

    I think I figured out the issue(s), the first is the title of my thread - it's misleading and I apologize for that - I am looking for the populated cells divided against the total number of cells in the cell set. The formula that you gave is correct but it unfortunately only divides against the populated cells, instead of the total cells, which is giving me 60% instead of the goal of 38%. Is there a function to accompany all cells (blank and nonblank) in the set?
    Last edited by gerst0230; 02-23-2012 at 02:34 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