Try...

=SUMPRODUCT(COUNTIF(OFFSET(INDIRECT("'"&ROW(INDIRE CT("1:31"))&"'!A1:A20")
,,{0,3,6},,{2,2,1}),"Name"))

or

=SUMPRODUCT(COUNTIF(OFFSET(INDIRECT("'"&D1:D31&"'! A1:A20"),,{0,3,6},,{2,2
,1}),"Name"))

....where D1:D31 contains the sheet names.

Hope this helps!

In article ,
DailyRich
wrote:

That's awesome, thanks a lot!

Now, is there a way to have it look through more than one set of
ranges? It works for one range (the A1:A1000 part), but I need it to
look through three or four different ranges on each sheet (say A1:B20,
D1:E20, and G1:G20).