Count Select

[poltergeist]

Sorry, I do not speak English. I support myself with a translator.

I have something like that.

symbol	data
I Kkow 130/21	28.06.2021
I Kkow 130/22	29.06.2021
I Kkow 130/23	30.06.2021
I Kkow 130/24	01.07.2021
I Kkow 130/25	26.07.2021
I Kkow 130/26	27.07.2021
I Kkow 130/27	28.07.2021
I Kkow 130/28	29.07.2021
I Kkow 130/29	02.08.2021

Formula: 

COUNT(SELECT([symbol], AND([data] >= [start date], [data] <= [end date])))

start date=1.07.2021

end date=31.07.2021

Formula result=5 (is correct)

How to make the formula result=1  (because it is one symbol)

[Marc_Dillon]

You're using SELECT wrong

https://help.appsheet.com/en/articles/2357314-select

Make sure to use [_THISROW]s in your select where appropriate as well.

[poltergeist]

I found a solution.

COUNT(UNIQUE(SELECT([symbol], AND([data] >= [start date], [data] <= [end date]))))