I'm so close to completion on this project. One problem I'm having.

=IF(COUNTIF($C$9:$C$33,B42)0,SUMPRODUCT(--($C$9:$C$33=B42),--($L$9:$L$33)))

Take this formula above. The following table looks like this:

C9:C33 displays names
B42 = one specific name
L9:L33 displays TRUE or FALSE answers

However, the array L9:L33 and C9:C33 may change for each month
(pertaining to each worksheet). The above formula WORKS if the ALL the
boxes in L9:L33 array is filled in w/ TRUE or FALSE. However, what do I
need to add to the formula in case the box is *blank*.

I thought of using the ISERROR, ISERR, ISNA, or something else to have
the formula NOT COUNT the blank box. Been working on this all day and
nothing seems to work. Doesn't seem difficult to fix but nothing is
working.


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