How about this way Peo, without the additional function:

=SUMPRODUCT(--(A1:A100={"P","HP"})*({1,0.5}))
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------


"Peo Sjoblom" wrote in message
...
One way

=SUMPRODUCT(COUNTIF(A1:A100,{"P";"HP"}),{1;0.5})

where your P/HP days are in A1:A100


Regards,

Peo Sjoblom



"ryanjh79" wrote:

I would like to use the countif function to count a letter a a half ".5"
instead of as a whole "1." The application that it would be used for is on
a
payroll workbook. i.e. "P" would eaqul a whole personal day whereas a
"HP"
would be a half of a personal day. From there I would like to add all of
the
"P's" and "HP's" in one Cell. this would be like 4.5 days used compared
with
4 days used (P,P,P,P, HP)=4.5
Thanks,

Brandon