View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jaydee jaydee is offline
external usenet poster
 
Posts: 11
Default exclude formulas when counting cells

Is there a "count" formula that will only count the DATE entry in a cell and
exclude the formula in the cell?

A1, A2, A3, A4 have =if(isblank) formulas linked to another file. If a date
auto populates in cell A1 and A4, the count should be 2. However, the
current count formula used in the spreadsheet shows 4 because the formula
counts any data in the 4 cells.