ExcelBanter - Counting from multiple columns

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Counting from multiple columns (https://www.excelbanter.com/excel-discussion-misc-queries/158547-counting-multiple-columns.html)

The BriGuy[_2_]

Counting from multiple columns

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

All times are GMT +1. The time now is 02:22 PM.