best way to combine formulas? (getting "array elements to countifs are of different size")

Hello,

Looking for some help trying to find the best way to combine a couple formulas.

On sheet 2 there's a countif formula that's working, it returns the count if there is one.

=if(Q:Q<>"",COUNTIF(Q:Q,Q50),"")

Now I want to use this with another sheet, so on that sheet, it's doing the same thing but also searching and adding that column from sheet 2...

=if(Q:Q<>"",COUNTIFS(Q:Q,Q163,'sheet 2'!Q:Q,Q163),"") (I get "array elements to countifs are of different size")

I'm not sure if I should be compounding the formula or just doing an add to that column or what would work better...Any ideas?

Thanks.

This kind of works... I guess I still would like to capture additional occurrences on the first sheet as well?.. if that makes sense.

I'm wondering is there a way to make one formula which scans two columns and returns that same count?.

The real life issue is I'm counting the number of returns on a number string I get, but weekly my sheet get's cut/pasted to another sheet....So if there's been 1 return on my sheet, and 2 returns on the other sheet, I still want to see (return count=3) on mine. (having the formula scan a column on mine and on the other and return the count on both or at least mine.

Whew...thanks.

Ya I know, there's reports and stuff ran off of the second sheet, this is a pretty big list of people who access this sheet so I'm trying to not have to change others workflows. They simply don't care about today, just everything before.