Hi,

It's only 'obvious' to you what you want not us. Try this

=(COUNTIF(B2:H2,"D")+COUNTIF(B2:H2,"N")+COUNTIF(B2 :H2,"VA
D")+COUNTIF(B2:H2,"VA-N"))*12

Mind the line wrap it's all on one line. Note that in your codes va d &
va-n the latter has a hyphen and this is replicated in the formula.

Mike

"Kris M" wrote:

actually i need "va-d" and "va-n" to also have a value of 12 -- "vac" and
"off" obviously have a zero value.

"Mike H" wrote:

How about this in I2 and drag down

=(COUNTIF(B2:H2,"D")+COUNTIF(B2:H2,"N"))*12

You didn't say what was to happen for - va d or va-n

Mike

"Kris M" wrote:

I'm working on a schedule that needs to count N or D and assign it a value of
12

the chart i'm working with looks something like this

sun mon tues wed thurs fri sat
mary vac vac vac vac vac va d va-n
tyler off off n n d d off
john d d d d off off d
joe n n off off n n n


what function can i use to count how many times a person works "n" or "va d"
or "va-n" or "d" and assign a value of 12 for each of those characters but a
value of ZERO for off or vac?