in K56 enter
=if(or("VTC","DTC","TTC"),1,"")

--
Regards,
Tom Ogilvy


"Technician 41706" wrote in
message ...
i will send this via e-mail if someone can figure it out... it is a job
log
for use by field serveice technicians I Have a JOb Type that is VTC for
video
trouble call, DTC for dat High Speed Internet trouble call, TTC for
telephony
trouble call. These Job types are considered customer contact jobs and we
must either make a sale while there or not make a sale. Based on this i
am
trying to calculate that if you are on a VTC customer contact job, lineB9,
the log will autimacally assign a number 1 to, line K56, which will then
give
the sum of 1's on line k79, which will then give a sum of the days contact
jobs on line L58. then convert it to a daily sales percentage on line N58.

I have all of it figured out except the part where you select the job type
from lines B9 through B92 and it automatically assines a 1 to lines K56
through K78. The Only Job types i want to assign a 1 to are VTC, DTC, TTC.
the last threee are non contact jobs and dont need a one.

Again i will e-mail this to anyone that can help figure it out and i will
be
eternally grateful.

Thank You Very Much