Forum Discussion

littlevillage's avatar
littlevillage
Iron Contributor
Jul 08, 2022
Solved

Countifs return 0

Hi All, In Database worksheet, the column X, I am trying to count the values in column J (Tồn kho worksheet) with criterias in column T (Database worksheet), the formula returns right results from r...
Formulas and Functions
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Jul 08, 2022

    littlevillage The formula looks for values in a range that stops on a row 28454. The missing values are below that row in the big list. change the formula to this:

     

    =COUNTIFS('Tồn kho'!J:J,Database!$A5)

     

    ..... and copy it down

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Jul 08, 2022

littlevillage The formula looks for values in a range that stops on a row 28454. The missing values are below that row in the big list. change the formula to this:

 

=COUNTIFS('Tồn kho'!J:J,Database!$A5)

 

..... and copy it down

Resources