Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Look up function
0 views
Skip to first unread message
Alicia Rittenhouse
Sep 24, 2004, 2:31:07 PM9/24/04
to
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?
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
Sep 24, 2004, 3:00:58 PM9/24/04
to
Hi
have a look at SUMIF
have a look at SUMIF
--
Regards
Frank Kabel
Frankfurt, Germany
"Alicia Rittenhouse" <AliciaRi...@discussions.microsoft.com>
schrieb im Newsbeitrag
news:D2D26A39-A5F1-4D9A...@microsoft.com...
Alicia Rittenhouse
Sep 24, 2004, 3:47:01 PM9/24/04
to
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!
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
Sep 24, 2004, 4:24:32 PM9/24/04
to
Hi
please describe with some more detail the layout of your data :-)
please describe with some more detail the layout of your data :-)
--
Regards
Frank Kabel
Frankfurt, Germany
"Alicia Rittenhouse" <AliciaRi...@discussions.microsoft.com>
schrieb im Newsbeitrag
news:72427344-CE68-4364...@microsoft.com...
Alicia Rittenhouse
Sep 24, 2004, 5:37:03 PM9/24/04
to
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!
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
Sep 24, 2004, 5:43:34 PM9/24/04
to
Hi
so row 1 contains the code and row 2 the number of hours. Thentry:
=SUMIF(1:1,"code",2:2)
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" <AliciaRi...@discussions.microsoft.com>
schrieb im Newsbeitrag
news:9A135140-28BB-43E7...@microsoft.com...
0 new messages