I need some help. I am trying to build a simple vacation tracker for the
office. I have built a small calender with each cell as one day in the year.
For each employee I am entering a "V" for when they take a vacation. I have
used the "count" funtion, which works great if the employee schedules a full
day of vacation. If I need ".5V" for a half day of vacation, I cannot add
this to my count for the number of days taken by the employee. Is there some
function I can use to add up all of the "V" and ".5V" for the month to see
the vacation time taken.
--
JEB

Why not put 1 for a Vacation day, .5 for half a day, then just sum the
range?

Regards,
Fred

"JEB" wrote in message
...
I need some help. I am trying to build a simple vacation tracker for the
office. I have built a small calender with each cell as one day in the
year.
For each employee I am entering a "V" for when they take a vacation. I
have
used the "count" funtion, which works great if the employee schedules a
full
day of vacation. If I need ".5V" for a half day of vacation, I cannot add
this to my count for the number of days taken by the employee. Is there
some
function I can use to add up all of the "V" and ".5V" for the month to see
the vacation time taken.
--
JEB

Hi Jeb
Try this =SUMPRODUCT(--(B1:Z1=".5v"))+SUMPRODUCT(--(B1:Z1="v"))
Change the range to your needs.
HTH
John
"JEB" wrote in message
...
I need some help. I am trying to build a simple vacation tracker for the
office. I have built a small calender with each cell as one day in the year.
For each employee I am entering a "V" for when they take a vacation. I have
used the "count" funtion, which works great if the employee schedules a full
day of vacation. If I need ".5V" for a half day of vacation, I cannot add
this to my count for the number of days taken by the employee. Is there some
function I can use to add up all of the "V" and ".5V" for the month to see
the vacation time taken.
--
JEB