Excel Spreadsheet

New Contributor

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 Replies
best response confirmed by vantonich (New Contributor)

@vantonich Try this:



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