How to use array formula for three variables?

M

MelissaS

I am trying to create a spreadsheet to track vacation, sick and holiday time
for 30 employees. Can anyone help me with the formulas? I want to have the
three totals summed up in one column at the end, is this possible? I will
enter any times like this: v3,s3,h0 in each daily column. Thanks =)
 
B

Bob Phillips

Melissa,

I think this is what you mean

=SUM(IF(NOT(ISERROR((LOWER(LEFT(A20:A29,1))="v")*(SUBSTITUTE(LOWER(A20:A29),
"v","")))),--(SUBSTITUTE(LOWER(A20:A29),"v",""))))

it is an array formula so commit with Ctrl-SHift-Enter. Add more for s and
h.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top