COUNTA (with countif) with OR condition

[Lebene]

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!

 

[Fluff]

How about
=SUM(COUNTIF(D7:U7,{"Declared","Attended"}))/COUNTA(D7:U7)

 

[Lebene]

Thank you, this worked a treat!! I had tried =COUNTIF(D7:U7,{"Attended",{"Declared"})/COUNTA(D7:U7) - in lieu with the help you gave be previously, I was just trying to see but it didn't do anything.
How come introducing the '=sum' element finally made it work?

How about
=SUM(COUNTIF(D7:U7,{"Declared","Attended"}))/COUNTA(D7:U7)

 

[Fluff]

Using the array {"Declared","Attended"} will give you two separate counts, so the SUM function simply adds them together.

 

[Lebene]

Ah, I see.
So essentially what Excel is doing, which isn't explicit in the formula is =SUM(COUNTIFSCRITERIA 1 + COUNTIFS CRITERIA 2

Using the array {"Declared","Attended"} will give you two separate counts, so the SUM function simply adds them together.

Thank you again!

 

[Fluff]

You're welcome & thanks for the feedback