Results 1 to 4 of 4

Thread: Autosum

  1. #1
    5 Star Lounger
    Join Date
    Aug 2006
    Posts
    784
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I'm putting X's in all of the rows where the corresponding names of guests have been invited to an event. Is it possible to do an Autosum at the very bottom row that adds up the total number of people who received an X?

    Regards,

    JMT

  2. #2
    Star Lounger
    Join Date
    Dec 2009
    Location
    Mexico City, D.F., Mexico
    Posts
    81
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I guess the function COUNTIF(range, criteria) will do the trick:
    =COUNTIF(A1:A175,"X")

    Note that "X" counts both "X" and "x" cells
    This eco-post is made of recycled electrons

  3. #3
    5 Star Lounger
    Join Date
    Aug 2006
    Posts
    784
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Is there a way to do it so that Excel will count all of the cells in a given column that have any number written therein?

  4. #4
    Star Lounger
    Join Date
    Dec 2009
    Location
    Mexico City, D.F., Mexico
    Posts
    81
    Thanks
    0
    Thanked 0 Times in 0 Posts
    In such case, the function COUNT(range) is your friend! It returns from the specified range the number of numeric values.

    Two other useful functions: COUNTBLANK(range) will count the number of empty cells. COUNTA(range) will count the number of cells with a content.
    This eco-post is made of recycled electrons

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •