Thread: How to not count cells which contain a formula that returns " "?
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jimster jimster is offline
external usenet poster
  
Posts: 1
Default How to not count cells which contain a formula that returns "
Bob Philips is wrong, the COUNTIF() function counts the matching text in the
cell range including those in formulas.
I had a column with the same formula in each cell. The cell returned blank
or "*". The countif() function gave 214 which was the number of cells
containing the formula! - there were only 46 asterisks displayed from the
formulas.
Reply With QuoteReply With Quote