Dr. Darrell Wrote:
I have a column which contains 20 cells with 4 negative values and 12
positive values.

I want to do a count, but I only want a count the positive valued
cells
minus the negative valued cells. so the result of the count in this
example
would be 12-4=8.

How do I write my function?

Darrell

Hi Darrell

Try this =SUM(COUNTIF(A1:A20,"0")-COUNTIF(A1:A20,"<0"))

This will ignore 0's, blanks and text


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=465879