Count

%3CLINGO-SUB%20id%3D%22lingo-sub-2833037%22%20slang%3D%22en-US%22%3ECount%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2833037%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20to%20count%20no%20of%20times%20pain%20has%20been%20repeated%20in%20column%207%20under%20data%20in%20column%201%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22491%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22280%22%3E1%3C%2FTD%3E%3CTD%20width%3D%2278%22%3E2%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E6%3C%2FTD%3E%3CTD%20width%3D%2269%22%3E7%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021306589%3C%2FTD%3E%3CTD%3EOut%20Patient%3C%2FTD%3E%3CTD%3EACUTE%3C%2FTD%3E%3CTD%3EPAIN%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3EACUTE%3C%2FTD%3E%3CTD%3EPAIN%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3ECJRONIC%3C%2FTD%3E%3CTD%3EPPI%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3EACUTE%3C%2FTD%3E%3CTD%3EPAIN%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3EACUTE%3C%2FTD%3E%3CTD%3EPAIN%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2833037%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2833236%22%20slang%3D%22en-US%22%3ERe%3A%20Count%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2833236%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1181738%22%20target%3D%22_blank%22%3E%40Pradyumna89%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETry%20something%20like%20this...%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DCOUNTIFS(A%3AA%2C%22%26lt%3B%26gt%3B%22%2CG%3AG%2C%22PAIN%22)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3ECheck%20the%20column%20reference%20in%20the%20formula.%20Currently%2C%20it%20is%20counting%20occurrences%20of%20%22Pain%22%20in%20Column%20G%20if%20there%20is%20data%20in%20Column%20A.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

How to count no of times pain has been repeated in column 7 under data in column 1

 

1267
2021306589Out PatientACUTEPAIN
  ACUTEPAIN
  CJRONICPPI
  ACUTEPAIN
  ACUTEPAIN
1 Reply

@Pradyumna89 

Try something like this...

=COUNTIFS(A:A,"<>",G:G,"PAIN")

Check the column reference in the formula. Currently, it is counting occurrences of "Pain" in Column G if there is data in Column A.