SOLVED

Excel Spreadsheet

%3CLINGO-SUB%20id%3D%22lingo-sub-2744444%22%20slang%3D%22en-US%22%3EExcel%20Spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2744444%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20taking%20a%20statistics%20class%20and%20I%20have%20a%20set%20of%20information%20that%20I%20am%20answering%20questions%20for.%20I%20am%20supposed%20to%20input%20%26gt%3B12%26lt%3B16.%20I%20have%20tried%20%3DCOUNTIF(A2%3AG4%2C%22%26gt%3B12%26lt%3B16%22)%20and%20I%20keep%20getting%20zero.%20I%20answered%20another%20question%20for%20%26lt%3B%3D12%20and%20used%20%3DCOUNTIF(A2%3AG4%2C%22%26lt%3B%3D12%22)%20and%20got%20the%20correct%20answer.%20What%20am%20I%20missing%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2744444%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2744681%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2744681%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1153822%22%20target%3D%22_blank%22%3E%40vantonich%3C%2FA%3E%26nbsp%3BTry%20this%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%3DCOUNTIFS(A2%3AG4%2C%22%26gt%3B12%22%2CA2%3AG4%2C%22%26lt%3B16%22)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
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.