Thread: COUNTIF
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
r2d3 r2d3 is offline
external usenet poster
 
Posts: 5
Default COUNTIF

Is there a function that I can use to find the occurence of a certain item
across several worksheets? Apparently the Countif cannot cross worksheet
boundaries. I have thought about just using the countif function on each
sheet and them summing them on a cover sheet, but I have 365 sheets to set
up. Any suggestions would be appreciated.