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