SOLVED

countifs value

Copper Contributor

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

Alcala1702_0-1662655807625.png

Alcala1702_0-1662656558578.png

 

 

3 Replies
best response confirmed by Alcala1702 (Copper Contributor)
Solution

@Alcala1702 

The 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.

thanks a lot!!

@Alcala1702 

You are welcome!

1 best response

Accepted Solutions
best response confirmed by Alcala1702 (Copper Contributor)
Solution

@Alcala1702 

The 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.

View solution in original post