View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Carolyn Carolyn is offline
external usenet poster
 
Posts: 60
Default Counting instances of data across worksheets

I am trying to count the number of times specific data occurs across multiple
worksheets in the same workbook. I thought COUNTIF would work, but I don't
seem to be able to set the range properly. basically, I want to always look
in the same cell on each worksheet and count the contents in a summary
worksheet. Any ideas??
--
carolyn