Thread: Countif looking at many sheets
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jock Jock is offline
external usenet poster
  
Posts: 440
Default Countif looking at many sheets
How can I adapt the following to also look in the same range in sheet1!,
sheet2! and sheet3! as well as sheet 4! ?
=COUNTIF(sheet4!Z$4:Z$4000,"b")
--
Traa Dy Liooar

Jock
Reply With QuoteReply With Quote