+ Reply to Thread
Results 1 to 5 of 5

Displaying Blank Cells

  1. #1
    Registered User
    Join Date
    10-29-2004
    Posts
    37

    Displaying Blank Cells

    Ok...almost done w/ this. This regards for more look than computation.

    =IF(COUNTIF($C$9:$C$37,B50)>0,SUMPRODUCT(--($C$9:$C$37=B50),--($L$9:$L$37=TRUE))/K50)

    I have this formula and works. But when the computation is not complete the results is FALSE in the cell. What I want to do is add a function to have the FALSE text removed and have it just a blank cell.

    I would like to do that with many other cells but not sure what code I have to enter. Thanks.

    Jason

  2. #2
    Biff
    Guest

    Re: Displaying Blank Cells

    Hi!

    Try this:

    =IF(COUNTIF($C$9:$C$37,B50)>0,SUMPRODUCT(--($C$9:$C$37=B50),--($L$9:$L$37=TRUE))/K50,"")

    Biff

    "drvortex" <[email protected]> wrote in
    message news:[email protected]...
    >
    > Ok...almost done w/ this. This regards for more look than computation.
    >
    > =IF(COUNTIF($C$9:$C$37,B50)>0,SUMPRODUCT(--($C$9:$C$37=B50),--($L$9:$L$37=TRUE))/K50)
    >
    > I have this formula and works. But when the computation is not
    > complete the results is FALSE in the cell. What I want to do is add a
    > function to have the FALSE text removed and have it just a blank cell.
    >
    > I would like to do that with many other cells but not sure what code I
    > have to enter. Thanks.
    >
    > Jason
    >
    >
    > --
    > drvortex
    > ------------------------------------------------------------------------
    > drvortex's Profile:
    > http://www.excelforum.com/member.php...o&userid=15896
    > View this thread: http://www.excelforum.com/showthread...hreadid=490263
    >




  3. #3
    Registered User
    Join Date
    10-29-2004
    Posts
    37
    Almost done. I fixed the FALSE problem but now I have a new error. The formula looks for name is C9:C33 and adds up the TRUEs and FALSEs for that name in the next array. Well, lets say in the second array it is blank. It tries to count up the True and Falses in the second array but want it to ignore the blank boxes. However, it wants to put a "0" for total number of TRUEs and for FALSE which is correct but when I tried to do the % of TRUEs it comes w/ the #DIV/0! error. I know you can't divide by 0 but what I want it to do is when the cell is blank just completely ignore it.

    I hope you understand what I"m asking. Thanks.

  4. #4
    Biff
    Guest

    Re: Displaying Blank Cells

    Hi!

    =IF(COUNTIF($C$9:$C$37,B50)>0,SUMPRODUCT(--($C$9:$C$37=B50),--($L$9:$L$37=TRUE))/K50,"")

    If:

    SUMPRODUCT(--($C$9:$C$37=B50),--($L$9:$L$37=TRUE))

    =0

    Then 0/K50 will return 0 unless K50 itself is 0 (or blank) and then it would
    return #DIV/0!

    So, test K50:

    =IF(AND(COUNTIF($C$9:$C$37,B50),K50>0),SUMPRODUCT(--($C$9:$C$37=B50),--($L$9:$L$37=TRUE))/K50,"")

    Biff

    "drvortex" <[email protected]> wrote in
    message news:[email protected]...
    >
    > Almost done. I fixed the FALSE problem but now I have a new error. The
    > formula looks for name is C9:C33 and adds up the TRUEs and FALSEs for
    > that name in the next array. Well, lets say in the second array it is
    > blank. It tries to count up the True and Falses in the second array
    > but want it to ignore the blank boxes. However, it wants to put a "0"
    > for total number of TRUEs and for FALSE which is correct but when I
    > tried to do the % of TRUEs it comes w/ the #DIV/0! error. I know you
    > can't divide by 0 but what I want it to do is when the cell is blank
    > just completely ignore it.
    >
    > I hope you understand what I"m asking. Thanks.
    >
    >
    > --
    > drvortex
    > ------------------------------------------------------------------------
    > drvortex's Profile:
    > http://www.excelforum.com/member.php...o&userid=15896
    > View this thread: http://www.excelforum.com/showthread...hreadid=490263
    >




  5. #5
    Registered User
    Join Date
    10-29-2004
    Posts
    37
    Wondeful. It works. I got into work and tada...today is going to be a good day. Thanks so much.

+ Reply to Thread

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