Look up function

[Guest]

I need a function for an employee attendance card. I want it to look at a
cell that would have the code of either v=vacation, s=sick, h=holiday and so
on and then add up the number of hours that is either in the same cell or a
different cell nearby for the corisponding letter. So that we can track how
many days people have left. Can you even do this? If so how would you
suggest going about this?

 

[Frank Kabel]

Hi
have a look at SUMIF

--
Regards
Frank Kabel
Frankfurt, Germany

"Alicia Rittenhouse" <[email protected]>
schrieb im Newsbeitrag
news[email protected]...

 

[Guest]

Where do I put the number that I want it to total after it looks up the
letter? Do they need to be in the same cell or next to each other? I tried
using the help, but it wasn't very helpful. Thanks!

 

[Frank Kabel]

Hi
please describe with some more detail the layout of your data

--
Regards
Frank Kabel
Frankfurt, Germany

"Alicia Rittenhouse" <[email protected]>
schrieb im Newsbeitrag

 

[Guest]

I have two rows for each month. On the top one I put the code for the
absence, on the line underneath I put the number of hours that the person was
out of the office. I could send you a copy of the document but I don't see
anywhere to attach anything. There are 24 rows all together for a whole
calendar year. I hope this helps, I have been trying to get the Sumif to
work but it keeps telling me it is invalid. Hope this helps!

 

[Frank Kabel]

Hi
so row 1 contains the code and row 2 the number of hours. Thentry:
=SUMIF(1:1,"code",2:2)

--
Regards
Frank Kabel
Frankfurt, Germany

"Alicia Rittenhouse" <[email protected]>
schrieb im Newsbeitrag