J,

=countif(a1:a3,"pt")/2

HTH,
Bernie
MS Excel MVP


"JGreig" wrote in message
...
I'm doing a staffing allocation. I have PT for part time staff. I want PT
to equal 0.5 in my formula. My formula now is =countif(a1:a3,"pt") How do I
make PT=0.5?