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:

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: