Try this:

=SUM(COUNTIF(B7:Q7,{"P","L"}),COUNTIF(B18:E18,{"P" ,"L"}))

--
Biff
Microsoft Excel MVP


"Loris" wrote in message
...
I have two non-contiguous ranges that contain individual letters. I need a
formula that will count the number of occurrences of the letters P and L
within those ranges, let's call them B7:Q7 and B18:E18. Can it be done
with
one formula or do I have to count the ranges separately and then add them
together?

I'm running Excel 2003. Thanks in advance for any help.