Text Values

[Susan]

Hello,

Can anybody help, I'm after making a spreadsheet in Excel to record times
for individuals, for example if I typed in 'early shift' with the value of
10 hours, after 'noon shift' 8 hours as well as 'late' shift at 12
hours...etc, the total values would all show in a totals cell for that
person.

I would appreciate any help with the above.

Love,

Susan

 

[Frank Kabel]

Hi Susan
see your response in public.Excel

 

[Bob Phillips]

Type the shift pattern in A, and in B1 use

=VLOOKUP(A1,{"early shift",10;"Noon shift",8;"late shift",12},2,False)

and copy down B

Then 3 rows at at the foot of B,

=SUMIF(A1:A100,"early shift",B1:B100)
=SUMIF(A1:A100,"noon shift",B1:B100)
=SUMIF(A1:A100,"late shift",B1:B100)

chanong the 100 for the real last row,

Or else you could do away with B and put these formulae in A101, A102, A103
(or wherever)

=COUNTIF(A1:A100,"early shift")*10
=COUNTIF(A1:A100,"noon shift")*8
=COUNTIF(A1:A100,"late shift")*12

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)