Formula "either-or"
 

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.

Formula "either-or"
 

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.

Formula "either-or"
 

=SUM(COUNTIF(A:A,{"Dog","Chien"}))

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"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.

Formula "either-or"
 

If you have a lot of English-French word pairs it may be beneficial to create
a code table, i.e., chien/dog = 1, pomme/apple = 2, etc. create a "Code"
column which would enter the appropriate code, whether the item in question
is in English or French. That way, you would only need to do the COUNTIF on
a single number, i.e., =COUNTIF(A1:A100,"1"), etc.

Dave


--
Brevity is the soul of wit.


"srain001" wrote:

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.