Your problem is that Countifs is looking for both criteria to be true. This,
of course, is impossible. You can't be both Armenia and Azerbaijan at the
same time.

Forget Countifs. Just use good old-fashioned Countif, as in:

=COUNTIF('[Member
List(1).xls]Sheet1'!$C$2:$C$1108,"azerbaijan")+COUNTIF('[Member
List(1).xls]Sheet1'!$C$2:$C$1108,"armenia")

Regards,
Fred.

"MOLLY66" wrote in message
...
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!