View Full Version : Excel Counting text cells in a column

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.

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

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?

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.

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