Excel Spreadsheet

[vantonich]

I am taking a statistics class and I have a set of information that I am answering questions for. I am supposed to input >12<16. I have tried =COUNTIF(A2:G4,">12<16") and I keep getting zero. I answered another question for <=12 and used =COUNTIF(A2:G4,"<=12") and got the correct answer. What am I missing?

[#2 · Accepted solution]

@vantonich Try this:

=COUNTIFS(A2:G4,">12",A2:G4,"<16")

[#3]

Thank you! I completely missed that. Your response corrected my error.