Try this

=countif(Sheet2!A:A, Sheet1!A2)

Sheet2!A:A contains the source data
Sheet1!A2 contains the country you want to count.
--
HTH,
Barb Reinhardt



"Molly66" wrote:

Hello

I have a spreadsheet (master spreadsheet) which counts the number of times
individual countries appear in one column on a linked spreadsheet. The
linked spreadsheet and range of cells always changes. How can I update my
master spreadsheet to count the number of times a country appears in the new
range of cells in the new linked spreadsheet? I figured out how to update
the link to a new spreadsheet but not how to change the range of cells.
--
Thanks in advance