characters and values
 

Hi,

I've a question about giving characters a value.
Let's say you have your schedule for work in your Excel sheet and ther
are several shifts with different time spaces your boss uses to let yo
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 i
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 whil
still using A, B and C insteas of 8, 4 and 2 ?

Thanks,
Partysqua

--
Partysqua
-----------------------------------------------------------------------
Partysquad's Profile: http://www.excelforum.com/member.php...fo&userid=2897
View this thread: http://www.excelforum.com/showthread.php?threadid=49900

characters and values
 

Try

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

"Partysquad" wrote
in message ...

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

characters and values
 

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