Just change the front part of it:
=IF(Sheet1!A2="","", ...

to this:
=IF(OR(Sheet1!A2={"","P"}),"", ...
which will trap the "P"
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"mdj0615" wrote in message
...
Thanks. That worked well, but now I have another question. All of the
cells
that don't have an A, L, etc have a P in the box. When I put a P in the
cells, I get an ##. How do I change the formula to when I put in a P,
there
is nothing put in the cell?