Hi,
Thank you very much for this suggestion and your valuable insight.
Indeed, I am convinced that this is part of the problem.
However, when I try this, the formula does indeed return a value, but
only 0 or 1 depending on whether I use COUNT or COUNTA. Regardless, it
doesn't return the proper value, (which, with the direct formula itself
is 2689, fyi).
Is there something else I might have to do in order to return the
correct value instead of 0 or 1, by any chance?
Any help is much appreciated.
-Pete
--
Peter Bernadyne
------------------------------------------------------------------------
Peter Bernadyne's Profile:
http://www.excelforum.com/member.php...fo&userid=7017
View this thread:
http://www.excelforum.com/showthread...hreadid=515892