Prev: fill colors
Next: if function
From: JEB on 19 Jan 2010 17:48
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
From: John on 19 Jan 2010 20:05
Hi Jeb
Try this =SUMPRODUCT(--(B1:Z1=".5v"))+SUMPRODUCT(--(B1:Z1="v"))
Change the range to your needs.
HTH
John
"JEB" <JEB(a)discussions.microsoft.com> wrote in message
news:CCD84413-FEA1-433E-A87A-5CF29C7B40DC(a)microsoft.com...
>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

From: Fred Smith on 19 Jan 2010 20:04
Why not put 1 for a Vacation day, .5 for half a day, then just sum the
range?

Regards,
Fred

"JEB" <JEB(a)discussions.microsoft.com> wrote in message
news:CCD84413-FEA1-433E-A87A-5CF29C7B40DC(a)microsoft.com...
>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

 | 
Pages: 1
Prev: fill colors
Next: if function