+ Reply to Thread
Results 1 to 3 of 3

Sum total for names

  1. 04-21-2007, 02:31 PM #1
    skylinekiller
    skylinekiller is offline
    Forum Contributor
    Join Date
    04-28-2004
    Location
    Tokyo
    MS-Off Ver
    Office 2016 pro plus
    Posts
    175

    Sum total for names

    Can someone please explain to me how I can get a sum total for all the people I have on my roster without having to create a seperate column? For example, I have a roster with names and I want a number to represent how many people I have on my roster. I have attached a copy of the roster.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-21-2007, 03:36 PM #2
    mrice
    mrice is offline
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967
    Sounds like you might need the COUNTA function.
    Martin
    Reply With QuoteRegister To Reply
  3. 04-21-2007, 04:16 PM #3
    davesexcel
    davesexcel is offline
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,480
    =COUNTA(O2:O50)
    counts the number of non blank cells
    ,
    Xlorate.com, Selection Codes, YouYube Channel
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1