Attendance Excel Formula

I am trying to find out how I can go about this. Please refer to the attached image.

This is somewhat related to the previous thread I posted before but this one is kinda complicated (I guess, for me). P is Present and L is Late. I know how to use the COUNTIF function, but I want to know if what I want is possible. It's like answering 1+1+2+1=1 or vice versa. I want to be able to have an answer of 1 even though the person was present 3 times or has been late once. Please help me.

In Joe Smith's row, P is the only letter being counted. =IFERROR(COUNTIF(B2:F2,"P")/COUNTIF(B2:F2,"P"),0)
In Earl Root's row, L is the one being counted. =IFERROR(COUNTIF(B3:F3,"L")/COUNTIF(B3:F3,"L"),0)

What I want is, in all rows, I want to be able to count both P and L but the Total or the result is still 1

It's like =IFERROR(COUNTIF(B2:F2,"P")/COUNTIF(B2:F2,"P"),0) and =IFERROR(COUNTIF(B3:F3,"L")/COUNTIF(B3:F3,"L"),0) all together. If i'm doing this wrong, please let me know.

\1

exactly what output should you want

Hi

In G2 Cell paste below function and drag down

Please Login or Register  to view this content.

What is your logic behind getting 1 in col. G for each row? or what are you trying to count to get 1 in col. G? Would you please explain it again?
Should it return 1 in col. G if present at least once in a week or what?

I don't get the logic but still try this

Formula:

Please Login or Register  to view this content.

There are two cases what I see.

1) If a student is present at least once in the week. Try this....

Please Login or Register  to view this content.

2) If a student is present at least once and absent at least once in a week. Try this....

Please Login or Register  to view this content.

Both the formula will return 1 in col. G if the condition is true otherwise a 0.
Which of these two cases suits your requirement?

Formula:

Please Login or Register  to view this content.

Originally Posted by akosibhon

This only counts the P. I want it like if I type just L, the return would still be 1 same return if I type just P.

What about this?

Please Login or Register  to view this content.

Glad I could help.
If that takes care of your question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.
Moreover you may also click on * (star) to Add Reputation to those who have put their time and efforts to help you in this forum. This is another way to say thanks to them.