Sep 08 2022 09:54 AM - edited Sep 08 2022 10:02 AM
Hello, i'm trying to count the number of times a date appears in a DB, but when i use the count ifs function the result is wrong, i don't understand why, ill show you the function i use and the DB (LINK):
This is a 131486 rows long DB
CONTAR.SI.CONJUNTO = Countifs.
Function: =CONTAR.SI.CONJUNTO(A1:A131486;">=01/08/2022";A1:A131486;"<=30/08/2022")
Result: 131370
Sep 08 2022 10:03 AM
SolutionThe formula works perfectly. Dates from 01/08/2022 to 30/08/2022 occur 131370 times in range A1:A131486 and the formula returns the correct and expected result.
Sep 08 2022 10:03 AM
SolutionThe formula works perfectly. Dates from 01/08/2022 to 30/08/2022 occur 131370 times in range A1:A131486 and the formula returns the correct and expected result.