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

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" wrote in
message ...

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

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

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),K500),SUMPRODUCT(--($C$9:$C$37=B50),--($L$9:$L$37=TRUE))/K50,"")

Biff

"drvortex" wrote in
message ...

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

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


--
drvortex
------------------------------------------------------------------------
drvortex's Profile: http://www.excelforum.com/member.php...o&userid=15896
View this thread: http://www.excelforum.com/showthread...hreadid=490263