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
Bookmarks