Home 
Search 
Today's Posts 
#1




Countif  Countif
I understand the COUNTIF formula, but how can I subtract the results of a column from the COUNTIF results of another column? Or can I? For instance, if my first COUNTIF formula gives me 63 in column A, how do I subtract the results of column B, which also contains a COUNTIF formula that equals 14.  maswinney  maswinney's Profile: http://www.excelforum.com/member.php...o&userid=16497 View this thread: http://www.excelforum.com/showthread...hreadid=278760 
#2




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 
#3




maswinney,
What end result are you trying to achieve? KL "maswinney" wrote in message ... I understand the COUNTIF formula, but how can I subtract the results of a column from the COUNTIF results of another column? Or can I? For instance, if my first COUNTIF formula gives me 63 in column A, how do I subtract the results of column B, which also contains a COUNTIF formula that equals 14.  maswinney  maswinney's Profile: http://www.excelforum.com/member.php...o&userid=16497 View this thread: http://www.excelforum.com/showthread...hreadid=278760 
#4




Why don't you give us your layout and the problem and the desired solution.
It's possible that a =sumproduct((rnga="joe")*(rngb=1)) would be your answer  Don Guillett SalesAid Software "maswinney" wrote in message ... I understand the COUNTIF formula, but how can I subtract the results of a column from the COUNTIF results of another column? Or can I? For instance, if my first COUNTIF formula gives me 63 in column A, how do I subtract the results of column B, which also contains a COUNTIF formula that equals 14.  maswinney  maswinney's Profile: http://www.excelforum.com/member.php...o&userid=16497 View this thread: http://www.excelforum.com/showthread...hreadid=278760 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Subtotal And Countif  Excel Discussion (Misc queries)  
Countif ???  Excel Worksheet Functions  
countif  Excel Worksheet Functions  
Countif, Sumif, If  help!  Excel Worksheet Functions  
countif, again  Excel Worksheet Functions 