countif sum of several data

[hoomantt]

Hi Dear Professors ;
I have a excel sheet that
in every row are sale of companies.
in every columns are month names.
then in every cell we have the sale of a month of a company!
I want in every column know that how many companies make approximately 80% of sale of that month.

 

[Hui]

Hoomantt

Remarkably all columns have 13 items making up 80%of each columns values

I used your subtotal table and added a rank to that
then linked that up to a data table and a helper column
Works like a charm

See attached:

I also changed the Dates in the Months Row so that the dates could be looked up