Adding columns and/or Rows of "X"x

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to add columns and rows on a spreadsheet/survey where people have
marked an "X" in several cells. I'm trying to count the "X"s by column and
by row. Somebody told me to type this in the cell I wanted the total to
appear:
=countif(a1:a34,"x") I have done so but when I try to total the column
using the auto sum symbol (like I would to add numbers) it doesn't work.
What am I doing wrong? Thanks.
 
Back
Top