Formula Needed

[John]

I am looking for a formula that will read (1/2 H) this for a register that i
am building and i need to read if there is a half days holiday as i have one
that reads if there is a holiday witch is =countif(k8:k17,"H") i need this to
link in with that formula so it count up half days holidays

would be greatful if there is anyone that could help...

Cheers

Hi

You could try:
=countif(k8:k17,"H") + (COUNTIF(K8:K17,"1/2 H")/2)

Hope this helps.
Andy.

"John" <John@discussions.microsoft.com> wrote in message
news:CB370206-4D51-4B74-B01F-8436FA8BE0BB@microsoft.com...
>I am looking for a formula that will read (1/2 H) this for a register that
>i
> am building and i need to read if there is a half days holiday as i have
> one
> that reads if there is a holiday witch is =countif(k8:k17,"H") i need this
> to
> link in with that formula so it count up half days holidays
>
> would be greatful if there is anyone that could help...
>
> Cheers

[Bob Phillips]

An alternative way is to use H for a full day, h for half days, and use

=SUMPRODUCT(--(ISNUMBER(FIND(LOWER("H"),A1:A10)))/2+
ISNUMBER(FIND(UPPER("H"),A1:A10)))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"John" <John@discussions.microsoft.com> wrote in message
news:CB370206-4D51-4B74-B01F-8436FA8BE0BB@microsoft.com...
> I am looking for a formula that will read (1/2 H) this for a register that
i
> am building and i need to read if there is a half days holiday as i have
one
> that reads if there is a holiday witch is =countif(k8:k17,"H") i need this
to
> link in with that formula so it count up half days holidays
>
> would be greatful if there is anyone that could help...
>
> Cheers

[Bob Phillips]

A better formula is

=SUMPRODUCT(EXACT(A1:A10,{"H","h"})*{1,0.5})

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"John" <John@discussions.microsoft.com> wrote in message
news:CB370206-4D51-4B74-B01F-8436FA8BE0BB@microsoft.com...
> I am looking for a formula that will read (1/2 H) this for a register that
i
> am building and i need to read if there is a half days holiday as i have
one
> that reads if there is a holiday witch is =countif(k8:k17,"H") i need this
to
> link in with that formula so it count up half days holidays
>
> would be greatful if there is anyone that could help...
>
> Cheers