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.