Displaying Blank Cells

[drvortex]

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

 

[Biff]

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]

Almost done. I fixed the FALSE problem but now I have a new error. Th
formula looks for name is C9:C33 and adds up the TRUEs and FALSEs fo
that name in the next array. Well, lets say in the second array it i
blank. It tries to count up the True and Falses in the second arra
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
tried to do the % of TRUEs it comes w/ the #DIV/0! error. I know yo
can't divide by 0 but what I want it to do is when the cell is blan
just completely ignore it.

I hope you understand what I"m asking. Thanks

 

[Biff]

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]

Wondeful. It works. I got into work and tada...today is going to be
good day. Thanks so much