PDA

View Full Version : Excel Counting text cells in a column

bpt2
27-06-2012, 12:35 PM
I have created a list of unique names derived from two worksheets using the formula =IF(ISERROR(MATCH('2006'!\$A3,'2007'!A:A,0)),'2006' !\$A3,""). Now I want to count the number of names in my new list but I can't find a way as cells containing the formula are not considered to be empty. I have tried Countif(a1:a300,"*") but this counts blank cells which contain the formula. Anyone help? I am using Excel 2003.

SolMiester
27-06-2012, 01:00 PM
deleted, thats wont work.....

bpt2
27-06-2012, 02:05 PM
I have found a solution by changing the formula to =IF(ISERROR(MATCH('2006'!\$A3,'2007'!A:A,0)),'2006' !\$A3," ") and then using Countif(a1:a300,"*")-Countif(a1:a300," "). I just need to add one additional feature which is to make the count dependent on a number in an adjacent column. Any suggestions?

bpt2
27-06-2012, 03:32 PM
Last question resolved with the formula: =COUNTIF(A\$22:A\$404,A3)-SUMPRODUCT((A\$22:A\$404=A3)*(B\$22:B\$404=" ")) where the adjacent number is in Column A22:A404 and the criteria is in A3.

stratex5
27-06-2012, 03:53 PM
Ok, a self fixed problem:)