Attempting to Countifs and Averageifs between two dates

Hello Everyone,

I am trying to countifs and aferageifs sold properties between two dates. This is the type of formula that I used: =COUNTIFS(Sold!$K$4:$K$24,">="&Sheet7!A11,Sold!K4:K24,"<"&Sheet7!A10)
=AVERAGEIFS('Raw Data'!L3:L501,'Raw Data'!K3:K501,">="&Sheet7!A11,'Raw Data'!K3:K501,"<"&A10)

When I add up the sum for countifs, it is giving me more than the number that I have (20). Can somebody please help me. I've been banging my head for the past 24 hours.

Thank you,
Michael

The formula in B10 refers to Sold!K3:K23 instead of Sold!K2:K22, B11 is Sold!K4:K24, B12 is Sold!K5:K25.

Change the references to absolute in B9 to

=COUNTIFS(Sold!$K$2:$K$22,">="&Analysis!A9,Sold!$K$2:$K$22,"<"&Analysis!A8)

and copy down