I am trying to create a timesheet using "v" for one vacation day and "1/2v"
for a half of vacation day. function to count so that the total be 11/2 (one
and a half) in a different cell. Do you have a function or functions I can
use to do this.

Hi,

You could try this

=COUNTIF(A:A,"v")+COUNTIF(A:A,"1/2v")/2

change the column to suit.

Mike

"KANDLEZ" wrote:


I am trying to create a timesheet using "v" for one vacation day and "1/2v"
for a half of vacation day. function to count so that the total be 11/2 (one
and a half) in a different cell. Do you have a function or functions I can
use to do this.

Maybe this:

=COUNTIF(B2:J2,"v")+COUNTIF(B2:J2,"1/2v")/2

--
Biff
Microsoft Excel MVP


"KANDLEZ" wrote in message
...

I am trying to create a timesheet using "v" for one vacation day and
"1/2v"
for a half of vacation day. function to count so that the total be 11/2
(one
and a half) in a different cell. Do you have a function or functions I can
use to do this.

THANK YOU! IT WORKS
--
KK


"KANDLEZ" wrote:


I am trying to create a timesheet using "v" for one vacation day and "1/2v"
for a half of vacation day. function to count so that the total be 11/2 (one
and a half) in a different cell. Do you have a function or functions I can
use to do this.