Counting rows from columns on multiple worksheets?

[Guest]

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

 

[Guest]

try
=sumproduct(--('all books'!A1:A1000="Suzie Smith"),--(C1:C1000="Tuesday"))
the --( changes the logical true false to a numeric 1,0.

you cannot use (before 2007) the shorthand for the full column
A:A is a non-no.

 

[Guest]

Assume you have 3 identically structured source sheets named as simply: x, y, z

In your summary sheet,
List the 3 sheetnames in A3 down, ie: x, y, z
Input the dual criteria in B1:B2, ie: Suzie Smith, Tuesday
Then place in B3
=SUMPRODUCT((INDIRECT("'"&$A3&"'!A2:A100")=B$1)*((INDIRECT("'"&$A3&"'!C2:C100")=B$2)))
Copy B3 down to return the counts from each sheet.
Then you could just total up the counts in say, B6: =SUM(B3:B5)