COUNTIFS adding values from another cell HELP!

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.

Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.

We don't want the actual file, or a subset of it, just a sample that represents the structure of the workbook, the layout of the sheet(s), and some "typical" data.

I cannot help with a solution without having something to work with. I can try to visualise what the data looks like, but what are the chances I get it right? And then the thread drags on, and on. Been there, done that, not doing it again. Up to you.

A formula to calculate the sum of values from cells Q8:Q257 if the value of cells K8:K257 is between 16-30

Sounds like you want SUMIFS rather than COUNTIFS.

For the counts:

Formula:

Please Login or Register  to view this content.

For the sum:

Formula:

Please Login or Register  to view this content.

WOW! That thread is way past my limited expertise w/ Excel. Some advanced level $#it there. I should have specified that Column K & Q are actually on another tab, figured I could just replace the K8:K257 from the tab, however I see K & Q all over that formula. I will see if I can figure it out to see if it still works after I mangle it from the other tabs. But I do sincerely thank you. I figured it was more of a =SUMIFS answer, I know ZERO about =LET.

LET simply allows parameters to be set up and it's worth learning.

In your case, all you have to change are the k and q parameters from this:

=LET(k,$K$8:$K$16,q,$Q$8:$Q$16,SUMIFS(q,k,">="&IFERROR(TEXTBEFORE(B9,"-")+0,91),k,"<="&IFERROR(TEXTAFTER(B9,"-")+0,9.9E+307)))

to this (choose the correct sheet name, of course):

=LET(k,Sheet2!$K$8:$K$16,q,Sheet2$Q$8:$Q$16,SUMIFS(q,k,">="&IFERROR(TEXTBEFORE(B9,"-")+0,91),k,"<="&IFERROR(TEXTAFTER(B9,"-")+0,9.9E+307)))

Nothing else needs changing at all.