Thread: Counting rows from columns on multiple worksheets?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
The BriGuy[_2_] The BriGuy[_2_] is offline
external usenet poster
  
Posts: 16
Default Counting rows from columns on multiple worksheets?
I am looking for a formula to count instances, from multiple sheets, where
criteria in one column and another column occur. For example I have 4
worksheets and I amd looking for all instances where column A in all books
=Suzie Smith AND where column C in all books = Tuesday. Any ideas?

Thanks

Reply With QuoteReply With Quote