Thread: COUNTIF: 2 criteria: Date Range Column & Text Column
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John Michl
 
Posts: n/a
Default COUNTIF: 2 criteria: Date Range Column & Text Column
Bob is not referencing the entire column he is referencing the range
from row 2 through row 200. The entire column would be represented by
$C:$C. This is not permitted in SUMPRODUCT.

- John

Reply With QuoteReply With Quote