View Single Post
  #2   Report Post  
Old November 15th 04, 09:39 PM
wmjenner
 
Posts: n/a
Default


5 1
6 2
7 3
8 4
9
10

2 4

Not sure if this is what you mean, but the last row in each column is
the sum of the countif. Column A adds up to 6 but, since you said you
wanted to subtract the countif of Col. B, 2 is the net answer. If you
want to see the result of both, put the subtraction in a separate
cell.

If you want the 2 to be the answer, then =countif($a$1:$a$6,"0")-b8.
The formula in b8 is simply =countif($b$1:$b$6,"").


--
wmjenner


------------------------------------------------------------------------
wmjenner's Profile: http://www.excelforum.com/member.php...fo&userid=5282
View this thread: http://www.excelforum.com/showthread...hreadid=278760