CountIF over a criteria range
===

I have the following columns of data:

`Pool Amount|Calculated Payment| 10% | 15% | 20% | 30% | 40% | 50% `

Pool Amount and Calculated Payment are static currency fields, the percentage fields all contain variations on this formula:

e.g. C2 `=IF(B2<(A2*0.9),A2*0.9,IF(B2>(A2*1.1),A2*1.1,B2))` 

The formula caps the calculated payment at the thresholds determined by the relevant % in relation to the Pool Amount. What I want to do is a count for each % field showing the number at the minimum and maximum. 

For one cell in the 10% field I would use:

Min `=COUNTIF(C2,A2*0.9)` and Max `=COUNTIF(C2,A2*1.1)`

I could then produce two columns of 0s and 1s and `SUM` them but it seems a bit clunky. Is there a variation on the following formula that I could use:

`=COUNTIF(C2:C1162, A2:A1162*0.9)` to show a total count in one cell?

 Is this potentially a job for a pivot table with a custom function?