J JRD Dec 1, 2007 #1 How do i count the number of cells in a column that do not contain a certain word or words.
C Chip Pearson Dec 1, 2007 #2 If you want to count the non-blank cells that do not contain a given value, use =COUNTA(A1:B10)-COUNTIF(A1:B10,C1) This will not count blank cells. If you want to include blank cells in the count, use =(ROWS(A1:B10)*COLUMNS(A1:B10))-COUNTIF(A1:B10,C1) In both formula, change A1:B10 to your actual range of data. -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site)
If you want to count the non-blank cells that do not contain a given value, use =COUNTA(A1:B10)-COUNTIF(A1:B10,C1) This will not count blank cells. If you want to include blank cells in the count, use =(ROWS(A1:B10)*COLUMNS(A1:B10))-COUNTIF(A1:B10,C1) In both formula, change A1:B10 to your actual range of data. -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site)
