Formula for attendance tracker

[Juliens]

Hi All,


I am trying to make a basic attendance for our school and would like to ask on how do I go about this;

If I am to put "L" in a cell (which means Late), it will count or display it as 1 (meaning the student has incurred 1 Late). And if I am to put "LL" (meaning the student incurred two lates, 1 in the morning and 1 in the afternoon in the same day) it will count or display it as 2?


Thank you and looking for all of your feedback.

 

[Russk68]

Re: Need HELP on formula for attendance tracker

I have gotten hundreds of replies with help here and this is the first time I have seen a question that I might be able to help with.
Try this:
=IF(A1="L",1,IF(A1="LL",2,""))
This is assuming that L or LL is being typed in cell A1.

 

[Juliens]

Re: Need HELP on formula for attendance tracker

Hey Russk68 thanks for this prompt reply! You really helped me with this one . But question, can that be applicable if the cell in A1 is in range? say...

=IF(A1:J1="L",1,IF(A1:J1="LL",2,""))

Can't try it right now since I am away from my desk.

Thanks again!

 

[orsm6]

Re: Need HELP on formula for attendance tracker

no it wont....it will return error

 

[Juliens]

Re: Need HELP on formula for attendance tracker

So how do I go about it? I should have included that criteria on my first post - sorry about that.
sort of like this...

B1 C1 D1 E1 F1[TABLE="width: 130"]
<tbody>[TR]
[TD]M[/TD]
[TD]T[/TD]
[TD]W[/TD]
[TD]Th[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]L[/TD]
[TD]LL[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Russk68]

Re: Need HELP on formula for attendance tracker

I'm a little confused.
Is row 2, where the numbers are, the formula result from the L's in row 3?

 

[AhoyNC]

Re: Need HELP on formula for attendance tracker

Based on Russk68's IF formula you could add the SUM function to it forming an array formula.

This formula must be entered with CTRL-SHIFT-ENTER.

Excel Workbook
	A	B	C	D	E	F	G
1		M	T	W	Th	F
2		1	2	3	4	5
3		L	LL				3
Sheet

 

[Juliens]

Re: Need HELP on formula for attendance tracker

WOW!

Thank you very much AhoyNC! That did it for me.
As I am a noob in excel, I'm beginning to appreciate this forum and all the helpful people in here.

Thanks also to those who's involved in this thread. I really appreciate it guys!