Thread: Countif
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Davor Županić Davor Županić is offline
external usenet poster
  
Posts: 3
Default Countif
How to merge (expand) range criteria for COUNTIF outside the sheet1.

=COUNTIF(C:C+[737.xls]Sheet1!$C:$C;C4)

That is not working.

How to fix that?


Reply With QuoteReply With Quote