Problem with countifs formula using two text criteria

Hello,

I am trying to count the number of times the United States comes up based on a Unique identifier (spreadsheet attached).

I used the following formula: =COUNTIFS(Locations_Cleaned!A$2:A$6971,'Search_By Supplier'!A2,Locations_Cleaned!B$4984:B$6971,"United States")

But it returns a #VALUE! error.

Does anyone know what is wrong with my formula?

Any help much appreciated.

Change 4984 to 2.

Or even simpler, change your formula to this:

=COUNTIFS(Locations_Cleaned!A:A,A2,Locations_Cleaned!B:B,"United States")

Ah ... thankyou! I missed the 4984.

Thanks for your help!!

You're welcome. Happy to help.

Thanks for the rep!