Another way:

=SUM(COUNTIF('Week 1'!N3:N10000,{"cr","on","cc","or"}))

Biff

"Biff" wrote in message
...
Hi!

Try this:

=SUMPRODUCT(--(ISNUMBER(MATCH('Week
1'!N3:N10000,{"cr","on","cc","or"},0))))

Biff

"PCLIVE" wrote in message
...
I'm trying to figure a way to simplify this COUNTIF formula by using the
OR Function. It works the way it is, but it seems like I should be able
to make it more simple.

=COUNTIF('Week 1'!N$3:N$10000,"CR")+COUNTIF('Week
1'!N$3:N$10000,"ON")+COUNTIF('Week 1'!N$3:N$10000,"CC")+COUNTIF('Week
1'!N$3:N$10000,"OR")


I've tried this with no success.
=COUNTIF('Week 1'!N$3:N$10000,OR("CR","ON","CC","OR"))

Any ideas?