Hi
Try
=SUMPRODUCT(--(A1:A1000={"dog","chien"}))
Change ranges to suit

--
Regards

Roger Govier


"srain001" wrote in message
...
The best way I can describe what I need is by example, so here goes!

I am currently creating a spreadsheet which is capturing information
in both
English and French. At month's end, we need to keep stats on how many
entries of certain elements we are getting. However, due to the
bilingual
nature of our company, entries are being entered in both English and
French.
Rather than creat two COUNTIF functions for both elements, is there a
way I
can combine them to capture both terms and put them in the same
COUNTIF Total?

What I mean:

Categoy:
Animal

English term: Dog
French term: Chien

Actual Entries:
Dog
Dog
Chien
Dog
Chien

Total entries which should show up: 5

Does an "either or" function exist which can help me out? I'd
rather not
creat two COUNTIF functions for this. Is there any way to combine
them?

thanx
S.