Adding columns and/or Rows of "X"x

[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.

 

[Ronx]

You may get an answer if you post to an Excel forum or newsgroup -
FrontPage is about building web pages.
--
Ron Symonds - Microsoft MVP (FrontPage)
Reply only to group - emails will be deleted unread.

http://www.rxs-enterprises.org/fp

FrontPage Support: http://www.frontpagemvps.com/

 

[David Berry]

You need to ask this in the Excel newsgroup. This one is for FrontPage