emulate the COUNTA function

System

This discussion was created from comments split from: Odd way to emulate excel formula counta().

Andrew P

Hi @Genevieve P.

I am attempting to use this same formula to count the completed tasks in a project and return a percentage but I don't believe I have this set up right to emulate the COUNTA function

KPH

Would this do what you need?

=COUNTIFS(Status21:Status26,"Completed")/COUNT(Status21:Status26)