Hello,
You may remember me from before, I was helped to full through three different attendance types. It works lovely and I'm still trying to understand it... haha...
I've come into another road bump. I had somehow figured out how to do countif with counta (I did it in a trance and was actually shocked when I checked one day and saw it) - my only issue is that I don't want it to count 'Declared' as a non-attendance and hence lowering the percentage I get:
[/URL][/IMG]
I'm using this formula:
=COUNTIF($D7:$U7,"Attended")/COUNTA($D7:$U7)
What I'm expecting to see in Workshop 2 overall attendance is 100%.
This formula didn't work:
=COUNTIF($D7:$U7,"Attended")+COUNTIF($D7:$U7,"Declared")/COUNTA($D7:$U7)
=COUNTIF($D7:$U7,"Attended")/COUNTA($D7:$U7)+COUNTIF($D7:$U7,"Declared")/COUNTA($D7:$U7)
Thanks for any help!
You may remember me from before, I was helped to full through three different attendance types. It works lovely and I'm still trying to understand it... haha...
I've come into another road bump. I had somehow figured out how to do countif with counta (I did it in a trance and was actually shocked when I checked one day and saw it) - my only issue is that I don't want it to count 'Declared' as a non-attendance and hence lowering the percentage I get:
![Capture.png](/board/proxy.php?image=http%3A%2F%2F%5BURL%3D%22https%3A%2F%2Fibb.co%2FVH2rL8H%22%5D%5BIMG%5Dhttps%3A%2F%2Fi.ibb.co%2FLQnb0fQ%2FCapture.png&hash=e4222402dc270dee709c5e63b15e499a)
I'm using this formula:
=COUNTIF($D7:$U7,"Attended")/COUNTA($D7:$U7)
What I'm expecting to see in Workshop 2 overall attendance is 100%.
This formula didn't work:
=COUNTIF($D7:$U7,"Attended")+COUNTIF($D7:$U7,"Declared")/COUNTA($D7:$U7)
=COUNTIF($D7:$U7,"Attended")/COUNTA($D7:$U7)+COUNTIF($D7:$U7,"Declared")/COUNTA($D7:$U7)
Thanks for any help!
Last edited by a moderator: