Problem with countif, index and sequence

Dear all,
I have a problem when using countif on the result of index with sequence. As the attachment, I would like to count how many A1 in the first ten largest of sum.
Firstly, I take successfully first ten largest of sum by using: index(sort(A1:C31,3,-1),sequence(10),2) (in E2) but when I put this formula into countif to count how many A1 in the result, it returns error in value: countif(index(sort(A1:C31,3,-1),sequence(10),2),"A1") (in F2).
The problem is from sequence in index but I don't know how to solve it.
Any help would be greatly appreciated.
Thank you.

Phung

Hello nhphung. Welcome to the forum.

Please try this formula in cell F2.

Formula:

Please Login or Register  to view this content.

Or similarly

Formula:

Please Login or Register  to view this content.

Originally Posted by nhphung

Thank you Dave for your prompt response.
I am sorry because I let you misunderstand my issue. I would like to count how many element whose 'Result' value is "A1" there are in the first 10 largest of 'Sum'. I can get this result if I write in cell F2: =countif(E2:E11,"A1") but I don't want to create the temporary result in E2. Is there any way to calculate directly the value without using the temporary array.
Thank you.

I thought that is what my formulas (both of them) did.

What am I missing?

Edit: Never mind. After looking at Gregb11's solution I figured out that I misinterpreted the instructions.

The first argument in COUNTIF will not receive an array or other calculation. It must define a Range. This can be done by at least 3 different means:

1. direct referencing like C4:C12 or H1:L150, etc.
2. using OFFSET or
3. or defining the upper and lower limits of the range via an INDEX(range,1st-row#,1st-column#):INDEX(range,last-row#,last-column#)

The latter one is tedious to built but avoids the volatility of OFFSET.

It appears you were attempting to do that last method and weren't quite able to complete it.