I am trying to find out how i can go about it. Please refer to the attached image.
P is Present and A is absent. I know how to use COUNTIF function but i want to know if what i want is possible. It's like answering 1+1+0+1=1 or vice versa. I want to be able to have an answer of 1 even though the person was present 3 times. Please help me
Bookmarks