Adding up number of cells in a column that contain an X

Question

How do I get a total please of number of cells in a column that I have put an X in?

sergeibaklan · Answer

MrGazbom&nbsp;
That could be&nbsp;
=COUNTIF(E$2:E$202,"X")
or
=SUMPRODUCT(--(E$2:E$202="X"))

mrgazbom · Answer

MrGazbom&nbsp;&nbsp;Sergei Baklan,Your Excel knowledge is Excellent!Yes that worked.Thank you very much.Gary

mrgazbom · Answer

SergeiBaklan&nbsp;Sergei,Your Excel knowledge is Excellent!Yes that worked.Thank you very much.Gary

sergeibaklan · Answer

MrGazbom&nbsp;
Gary, glad to help

abiola1 · Answer

MrGazbom&nbsp;
&nbsp;
As variant, you can simply use COUNTA Function as seen in the caption below and the attachment

&nbsp;

Forum Discussion