Count text as a value

[mechpm]

Count text as a value


I have I worksheet that tracks manpower on all our projects up to two years. I use letters ( F= foreman, M = mechanic ect.) I use count if to find the type of labor is on each project however, I needed to control the dollar value as-well.

Is there a way to count F (as in foreman) as $23.75?


Thx

R W

[Yogi Anand]

On 2002-05-13 19:12, mechpm wrote:
Count text as a value


I have I worksheet that tracks manpower on all our projects up to two years. I use letters ( F= foreman, M = mechanic ect.) I use count if to find the type of labor is on each project however, I needed to control the dollar value as-well.

Is there a way to count F (as in foreman) as $23.75?


Thx

R W

Hi mechpm:
If i understood you correctly, you already have a CountIf of F
then why not just do

= (count_of_F)*23.75

Please post back if it works for you ... otherwise explain a little further and let us take it from there!