Results 1 to 10 of 10

Problem with countif, index and sequence

Threaded View

  1. #1
    Registered User
    Join Date
    03-21-2023
    Location
    Ho Chi Minh
    MS-Off Ver
    office 365
    Posts
    4

    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
    Attached Files Attached Files
    Last edited by nhphung; 03-21-2023 at 10:27 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. After filtered, index maintaining sequence
    By josephteh in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-19-2023, 03:27 PM
  2. [SOLVED] How to ignor #N/A with INDEX, SORT and SEQUENCE formula
    By Larry1957 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-02-2022, 07:27 PM
  3. [SOLVED] Index/Sort/Sequence with criteria
    By Maike in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-03-2022, 02:25 PM
  4. #NA Problem with Index, Match, Countif formula
    By KATPIF in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-19-2014, 09:43 AM
  5. [SOLVED] IF,COUNTIF, INDEX,MATCH problem to list-out eligible name list.
    By pejoi in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-25-2013, 06:25 AM
  6. How to use Countif to test if a sequence appears within an array ?
    By masterinex in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-29-2013, 05:11 AM
  7. Index Match / Countif / Offset problem
    By smalone in forum Excel General
    Replies: 1
    Last Post: 03-12-2009, 06:15 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1