formula Help

  • Thread starter Thread starter John
  • Start date Start date
J

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
 
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.
 
Back
Top