SOLVED

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)
Solution

@vantonich Try this:

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

 

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