Google Sheets - CountIFS

%3CLINGO-SUB%20id%3D%22lingo-sub-2931113%22%20slang%3D%22en-US%22%3EGoogle%20Sheets%20-%20CountIFS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2931113%22%20slang%3D%22en-US%22%3E%3CP%3EWhy%20function%26nbsp%3B%3CSPAN%20class%3D%22%22%3E%3D%3C%2FSPAN%3E%3CSPAN%20class%3D%22%22%3ECOUNTIFS%3C%2FSPAN%3E%3CSPAN%20class%3D%22%22%3E(%3C%2FSPAN%3E%3CSPAN%20class%3D%22%22%3E(%3C%2FSPAN%3E%3CSPAN%3EC2%3AC110%3C%2FSPAN%3E%3CSPAN%20class%3D%22%22%3E%3B%3C%2FSPAN%3E%3CSPAN%20class%3D%22%22%3E%22%26lt%3B5%22%3C%2FSPAN%3E%3CSPAN%20class%3D%22%22%3E%3B%3C%2FSPAN%3E%3CSPAN%3EC2%3AC110%3C%2FSPAN%3E%3CSPAN%20class%3D%22%22%3E%3B%3C%2FSPAN%3E%3CSPAN%20class%3D%22%22%3E%22%26gt%3B3%22%3C%2FSPAN%3E%3CSPAN%20class%3D%22%22%3E)%3C%2FSPAN%3E%3CSPAN%20class%3D%22%22%3E)%20is%20wrong%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2931113%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2931148%22%20slang%3D%22en-US%22%3ERe%3A%20Google%20Sheets%20-%20CountIFS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2931148%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1208349%22%20target%3D%22_blank%22%3E%40Annasakh%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DCOUNTIFS(C2%3AC110%2C%22%26lt%3B5%22%2CC2%3AC110%2C%22%26gt%3B3%22)%3C%2FP%3E%3CP%3EIs%20this%20what%20you%20are%20looking%20for%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2931346%22%20slang%3D%22en-US%22%3ERe%3A%20Google%20Sheets%20-%20CountIFS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2931346%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1208349%22%20target%3D%22_blank%22%3E%40Annasakh%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWhat%20do%20you%20mean%20under%20%22wrong%22%20exactly%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Why function =COUNTIFS((C2:C110;"<5";C2:C110;">3")) is wrong?

2 Replies

@Annasakh 

=COUNTIFS(C2:C110,"<5",C2:C110,">3")

Is this what you are looking for?

@Annasakh 

What do you mean under "wrong" exactly?