formula Help

[John]

I have a pivot table that breaks up a list of vendors and
how many times that vendor invoiced us.

I need a formula that will look through column M6:M865 and
see what percentage of the vendors billed 5 times or less

Can some one please help?

John

 

[Dave R.]

Does a pivot table play into the equation here?

Percentage of those billed 5 times or fewer

=COUNTIF(M6:M865,"<="&5)/COUNTA(M6:M865)

format as percentage.