percentage

aned koebsch · Dec 16, 2010

HI,

how can I calculate the percentage of cells that have a certain characteristic?
EI, % of cells fro A1:A45 that have the word ontime?

Thanks
Aned

Submitted via EggHeadCafe
Microsoft SQL Server DBA For Beginners
http://www.eggheadcafe.com/training-topic-area/SQL-Server-DBA/6/SQL-Server-DBA.aspx

joeu2004 · Dec 17, 2010

how can I calculate the percentage of cells that have a certain
characteristic? EI, % of cells fro A1:A45 that have the word ontime?

=countif(A1:A45,"*ontime*")/counta(a1:a45)

formatted as Percentage

Gord Dibben · Dec 17, 2010

=COUNTIF(A1:A45,"ontime")/COUNTA(A1:A45)

Format as percent.

Gord Dibben MS Excel MVP