Sorting Table Issue - Queries shows different results after sorting Table

[Trie1977]

Hello Excellers,

Many thanks to KRice who helped me a lot with a previous question.

I try to search for answers as much as I can before posting a thread, I just couldn't find the answer. This time I have a table. Beside that table are queries. When sorting the table dates for example, the results of the queries become incorrect. I understand why. The order of the dates for let's say the weekly, is important because the query is based on fibonacci levels fromlast week. It is logical when I change the date order, the outcomes are different.

But what is the solution here?

Thanks anyways.

Count_New.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
2									UNSORTED - THE CORRECT ANSWER
3	Date	TimeFrame	SwingCount	Duration	Bias	Retracement	FibRatio		Weekly				Daily				H4
4	2018-04-15	Weekly	664	7	buy	104,9%	100,0		61,8	100,0	0		61,8	100,0	1		61,8	100,0	0
5	2018-08-12	Weekly	1714	17	sell	258,1%	261,8		61,8	127,0	0		61,8	127,0	0		61,8	127,0	0
6	2018-08-30	Daily	381	11	buy	69,1%	61,8		61,8	150,0	0		61,8	150,0	0		61,8	150,0	0
7	2018-09-16	Weekly	636	5	buy	37,1%	38,2		61,8	161,8	0		61,8	161,8	0		61,8	161,8	1
8	2018-09-20	Daily	513	11	buy	134,6%	127,0		61,8	261,8	0		61,8	261,8	0		61,8	261,8	0
9	2018-12-30	Weekly	867	15	sell	136,3%	127,0		100,0	261,8	1		100,0	261,8	0		100,0	261,8	0
10	2019-03-10	Weekly	950	10	buy	109,6%	100,0		127,0	100,0	2		127,0	100,0	0		127,0	100,0	0
11	2019-09-01	Weekly	1422	25	sell	149,7%	127,0
12	2019-12-08	Weekly	1556	14	buy	109,4%	100,0		SORTED BY DATE (NO FORMULA HERE TO SHOW THE PROBLEM)
13	2020-03-15	Weekly	2105	14	sell	135,3%	127,0		Weekly				Daily				H4
14	2021-07-20	Daily	337	6	sell	65,2%	61,8		61,8	100,0	0		61,8	100,0	0		61,8	100,0	0
15	2021-07-30	Daily	411	8	buy	122,0%	100,0		61,8	127,0	0		61,8	127,0	1		61,8	127,0	0
16	2021-08-23	Daily	381	15	sell	92,7%	88,6		61,8	150,0	0		61,8	150,0	0		61,8	150,0	0
17	2021-10-01	Daily	501	11	sell	131,5%	127,0		61,8	161,8	0		61,8	161,8	0		61,8	161,8	0
18	2021-12-08	H4	663	21	sell	157,5%	150,0		61,8	261,8	0		61,8	261,8	1		61,8	261,8	0
19	2022-01-12	H4	578	15	buy	87,2%	88,6		100,0	261,8	0		100,0	261,8	0		100,0	261,8	0
20	2022-01-27	H4	380	6	sell	65,7%	61,8		127,0	100,0	2		127,0	100,0	0		127,0	100,0	0
21	2022-03-08	H4	663	25	sell	174,5%	161,8
SortTable

Cell Formulas
Range	Formula
K4:K10	K4	=COUNTIFS($B$4:$B$21,$I$3,$G$4:$G$21,I4,$G$5:$G$22,J4)
O4:O10	O4	=COUNTIFS($B$4:$B$21,$M$3,$G$4:$G$21,M4,$G$5:$G$22,N4)
S4:S10	S4	=COUNTIFS($B$4:$B$21,$Q$3,$G$4:$G$21,Q4,$G$5:$G$22,R4)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B4:B9	Cell Value	=$Q$3	text	NO
B4:B9	Cell Value	=$M$3	text	NO
B4:B9	Cell Value	=$I$3	text	NO
B10:B21	Cell Value	=$Q$3	text	NO
B10:B21	Cell Value	=$M$3	text	NO
B10:B21	Cell Value	=$I$3	text	NO