percentage

[aned koebsch]

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]

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]

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

Format as percent.


Gord Dibben MS Excel MVP