COUNTIFS adding values from another cell HELP!

[Destyn]

I have a sheet that I need help with a formula.

I have this formula for one cell:
=COUNTIFS(K8:K257,">15",K8:K257,"<31")

I need a formula for cell D10 that will take the values from Q8:Q57 if they align with the results from the corresponding formula above.

i.e. add all the values of Q8:Q57 that cell K8:K257 are between 15 & 30.

I know I have used this in the past, however my memory is escaping me and I know it is something simple.

Lets say Formula 1 is in C10 and the new formula would be in D10 if that matters which I do think it is irrelevant.

Thank you in advance.