...in Testing Sheet 2 column A is a fixed column of names, I'd like to return the count of the two tabs in Testing 1 to match the name in Column A of Testing 2
Please use the following formula
"select Col1, count(Col1) where Col1 is not null group by Col1 label count(Col1) 'Totals' "),2,0)))
In the formula I did not use
IMPORTRANGE. It is very easy though. All you have to do is change the ranges to your needs like
If still in need, please let us know.