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.