Excel – Counting “X’s” in a Column

A question that comes up quite often with respect to Excel spreadsheets – is how to create a formula that will add up/count the number of cells in a column containing "X’s":

If you have a specific column or columns, that you have put an X in and want to count the total # of X’s in a specific column, for example for attendance or other criteria, the formula you would enter in the “total cell” is noted below. Be sure however to enter the correct column & line ID’s…

Example – In your excel spreadsheet – Column C, you have put several X’s in Rows 1 thru 28, and want to now count the # of X’s in Column C, the correct formula that would be noted in the total cell C29 would be:

=COUNTIF(C1:C28,"X")