Take a look at

http://www.mcgimpsey.com/excel/doubleneg.html

In article ,
"Marty" wrote:

Didn't work. Still yields a zero.

I assume you intended me to replace the "--" with the A2:A500 range.

Also, not sure why you're suggesting the use of SUMPRODUCT, since all I want
to do is count the cells.

What am I missing? Please say more.