I'm not following the specifics of your request? Do you have the countif
function on the master page? What do you mean by "update links". What
links do you want to update? What specifically is in them? Could you
replace those links with the "hyperlink" function somehow?
--
HTH,
Barb Reinhardt



"Molly66" wrote:

Hi Barb

Thanks for your quick response. Sorry, I've probably not been clear. My
function to count the countries is fine, it's just when I try to update my
links to a new spreadsheet and new range that I don't know what to do. I
have used the edit/link option to update my master spreadsheet to look at a
new spreadsheet, which is fine, but I want to change the range as well.

Thanks in advance


"Barb Reinhardt" wrote:

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