MrGazbomCopper ContributorApr 25, 2020Adding up number of cells in a column that contain an X How do I get a total please of number of cells in a column that I have put an X in? Initial marketing LinkedIn X.xls60 KB
SergeiBaklanDiamond ContributorApr 25, 2020MrGazbom That could be =COUNTIF(E$2:E$202,"X") or =SUMPRODUCT(--(E$2:E$202="X"))Initial marketing LinkedIn X.xls62 KB
MrGazbomCopper Contributor to SergeiBaklanApr 25, 2020SergeiBaklan Sergei,Your Excel knowledge is Excellent!Yes that worked.Thank you very much.GarySergeiBaklanDiamond Contributor to MrGazbomApr 25, 2020MrGazbom Gary, glad to help
MrGazbomCopper Contributor to SergeiBaklanApr 25, 2020SergeiBaklan Sergei,Your Excel knowledge is Excellent!Yes that worked.Thank you very much.Gary
