Forum Discussion

Bee501972's avatar
Bee501972
Copper Contributor
Sep 01, 2022

Displaying the rows counted in a countifs formula

Hi

 

I have created a formula using countifs. I now want to display the actual data in the rows that have been counted. Please help to suggest the function that I can use to display the actual rows in excel.

Thanks

Formulas and Functions

2 Replies

  • alannavarro's avatar
    alannavarro
    Iron Contributor
    Sep 01, 2022

    If you have office 365, in some cases, the function: Filter () can do exactly what you are looking for.

     

    In this example, we have an array in Column A from numbers 1 to 36 and we have a condition greater than 10. 

     

    So, we use the formula Filter( array , array > 10) and now it returns the values.

     

    The filter function can accept more than one condition, for example:

    Filter ( array , (array > 10) * ( array < 20) )

     

    Bee501972  

    • Bee501972's avatar
      Bee501972
      Copper Contributor
      Sep 01, 2022

      thank you alannavarro 

       

      I have tried filter with the following formula and I keep getting an error saying I have too many arguments

       

      Filter(sheet!$I:$I,sheet2!$B29,INDIRECT(sheet2!A29),">="&Sheet2!Q2)