function help for counting text as a value....
If you are getting the 11 by counting the number of cells which have
something other than "OFF", and you then want to multiply the 11 by 12, then
perhaps
=(COUNTA(B9:AA9)-COUNTIF(B9:AA9,"OFF"))*12
Change the range references as appropriate.
--
David Biddulph
"Kris M" wrote in message
...
I have a schedule spreadsheet. i have 7 names in column A starting at row 4
the assignments are in Column B through O representing 2 weeks. (yes i
have
them labeled too in rows 2 and 3 for day of the week and the date)
i can't remember the formula for calculating the assignment as a value of
12.
here is an example of my spreadsheet.
Sun Mon Tues Wed Thurs Fri Sat Sun Mon Tues Wed Thurs Fri Sat
17-Jan 18-Jan 19-Jan 20-Jan 21-Jan 22-Jan 23-Jan 24-Jan 25-Jan 26-Jan
27-Jan 28-Jan 29-Jan 30-Jan
Theresa AJ D AJ D OFF AJ D AJ D AJ D AJ D OFF OFF AJ D AJ D AJ D AJ D AJ D
Stephanie
Kris OFF AJ N AJ N AJ N AJ N AJ N AJ N AJ N AJ N OFF OFF AJ N AJ N AJ N
Lawahid AJ T AJ T AJ T AJ T AJ T OFF OFF AJ T AJ T AJ T AJ T AJ T OFF OFF
Amanda VA D VA D AJ D OFF OFF VA D VA D VA D AJ D VA D VA D VA D VA D OFF
David AJ N VA N VA N VA N VA N OFF VA N VA N VA N AJ N VA N OFF VA N VA N
Mike VA N OFF VA D VA D VA D VA N OFF AJ D VA D VA N AJ N VA N OFF VA D
now without counting on fingers and toes i can see that Mike is working 11
shifts . What function can I use to show that he would be working 132
hours
in this 2 week period?
|