Forum Discussion
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 row 3 to row 117, but it returns 0 from row 118 to row 137
This is my formula: =COUNTIFS('Tồn kho'!$J$2:$J$28454,Database!$A118)
My Platform OS: Windows 10 pro
Office version: 2021
I have added an image and the link of sample file below
Thank you
https://docs.google.com/spreadsheets/d/1-2ViSyFS3d7l7-k30GRzifFL6waL7wF2/edit?usp=sharing&ouid=112310544159929632856&rtpof=true&sd=true
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
2 Replies
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
