I have a spreadsheet with countries in one column. I am trying to count the
number of times Armenia and Azerbaijan appear in this one column as a total.
I am using this function =COUNTIFS('[Member
List(1).xls]Sheet1'!$C$2:$C$1108,"azerbaijan",'[Member
List(1).xls]Sheet1'!$C$2:$C$1108,"armenia") where Member List is the name of
my spreadsheet and the range I want to counted is C2:C1108. Cans omeone
please tell me where I'm going wrong? Much appreciated!