characters and values

[Partysquad]

Hi,

I've a question about giving characters a value.
Let's say you have your schedule for work in your Excel sheet and there are several shifts with different time spaces your boss uses to let you work. These time spaces are used as characters.

For instance A is an 8 hour shift and B is a 6 hour shift, while C is just a 2 hour shift.

Cell A1 = Monday, Cell A2 = A
B1 = Tuesday, B2 = B
C1 = Wednesday, C2 = C
D1 = Thursday, D2 = A
E1 = Friday, E2 = A
F1 = Total hours, F2 = sum A2..E2

How can I make sure F2 will tell me I would have worked 32 hours while still using A, B and C insteas of 8, 4 and 2 ?

Thanks,
Partysquad

[Barb Reinhardt]

Try

=COUNTIF(A2:E2,"A")*8+COUNTIF(A2:E2,"B")*4+COUNTIF(A2:E2,"C")*2

"Partysquad" <[email protected]> wrote
in message news:[email protected]...
>
> Hi,
>
> I've a question about giving characters a value.
> Let's say you have your schedule for work in your Excel sheet and there
> are several shifts with different time spaces your boss uses to let you
> work. These time spaces are used as characters.
>
> For instance A is an 8 hour shift and B is a 6 hour shift, while C is
> just a 2 hour shift.
>
> Cell A1 = Monday, Cell A2 = A
> B1 = Tuesday, B2 = B
> C1 = Wednesday, C2 = C
> D1 = Thursday, D2 = A
> E1 = Friday, E2 = A
> F1 = Total hours, F2 = sum A2..E2
>
> How can I make sure F2 will tell me I would have worked 32 hours while
> still using A, B and C insteas of 8, 4 and 2 ?
>
> Thanks,
> Partysquad
>
>
> --
> Partysquad
> ------------------------------------------------------------------------
> Partysquad's Profile:
> http://www.excelforum.com/member.php...o&userid=28970
> View this thread: http://www.excelforum.com/showthread...hreadid=499001
>

[Gary''s Student]

In A3 enter:

=(A2="A")*8+(A2="B")*6+(A2="C")*2
and copy thru E3

In F2 enter:

=SUM(A3:E3)

--
Gary''s Student


"Partysquad" wrote:

>
> Hi,
>
> I've a question about giving characters a value.
> Let's say you have your schedule for work in your Excel sheet and there
> are several shifts with different time spaces your boss uses to let you
> work. These time spaces are used as characters.
>
> For instance A is an 8 hour shift and B is a 6 hour shift, while C is
> just a 2 hour shift.
>
> Cell A1 = Monday, Cell A2 = A
> B1 = Tuesday, B2 = B
> C1 = Wednesday, C2 = C
> D1 = Thursday, D2 = A
> E1 = Friday, E2 = A
> F1 = Total hours, F2 = sum A2..E2
>
> How can I make sure F2 will tell me I would have worked 32 hours while
> still using A, B and C insteas of 8, 4 and 2 ?
>
> Thanks,
> Partysquad
>
>
> --
> Partysquad
> ------------------------------------------------------------------------
> Partysquad's Profile: http://www.excelforum.com/member.php...o&userid=28970
> View this thread: http://www.excelforum.com/showthread...hreadid=499001
>
>