These have all been good suggestions, some of which worked and others did
not appear to. However, I have gone with yours, Biff, as it appears to be
the simplist one.

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

Thanks to all.
Paul

"Biff" wrote in message
...
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?