Forum Discussion
countifs value
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 https://docs.google.com/spreadsheets/d/1FodHLvQY7iE0gZRQev1zUaoRmsy170rF/edit?usp=sharing&ouid=109135818644335151607&rtpof=true&sd=true:
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
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.
3 Replies
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!!
You are welcome!
