Hi Lori

One way
=SUMPRODUCT(($B$1:$B$1000="P")*($H$1:$H$1000=100% ))
Change ranges to suit, but note you can't use whole columns as ranges
(except for XL2007)
--
Regards
Roger Govier

"Lori" wrote in message
...
Hi, I'm new to this and I have probably a easy question. I'm trying to
count
the following. If Column B has a P in it and Column H = 100% or more I
would
like it to count. Sounds pretty easy but for the life of me I can't
figure
it out.

Thanks