+ Post New Thread
Results 1 to 2 of 2
MIS Systems Thread, Easy spreadsheet function in Technical; I'm having a stupid day. Can somebody please help me out? I have a spreadsheet and I want to count ...
  1. 19th March 2008, 11:18 AM #1
    park_bench
    park_bench is offline
    Join Date
    Nov 2006
    Location
    Lancashire
    Posts
    92
    Thank Post
    33
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Send a message via MSN to park_bench

    Easy spreadsheet function

    I'm having a stupid day. Can somebody please help me out?

    I have a spreadsheet and I want to count all the cells in a column that are not blank.

    What function/operator do I need please?

    Thanks

    Ben
    Reply With Quote Reply With Quote
  2. 19th March 2008, 11:20 AM #2
    Jona
    Jona is offline
    Jona's Avatar
    Join Date
    May 2007
    Location
    Aberystwyth
    Posts
    438
    Thank Post
    9
    Thanked 44 Times in 43 Posts
    Rep Power
    17
    COUNTA(B1:B5)

    where B1:B5 is your range.

    Ref:
    http://www.contextures.com/xlFunctions04.html#CountA
    Last edited by Jona; 19th March 2008 at 11:21 AM. Reason: added ref
    Reply With Quote Reply With Quote

  3. Thanks to Jona from:

    park_bench (19th March 2008)
SHARE:
+ Post New Thread

Similar Threads

  1. Subscript error on vb split function
    By ryan_powell in forum Coding
    Replies: 0
    Last Post: 1st August 2007, 12:35 PM
  2. Excel - Spreadsheet Manipulation
    By danIT in forum Windows
    Replies: 1
    Last Post: 3rd July 2007, 01:28 PM
  3. SIMS .net Permissions Spreadsheet
    By Heebeejeebee in forum MIS Systems
    Replies: 4
    Last Post: 7th June 2007, 07:59 AM
  4. FN + F5 function key does not work
    By alexknight in forum Hardware
    Replies: 8
    Last Post: 7th February 2007, 03:32 PM
  5. google spreadsheet
    By russdev in forum Educational Software
    Replies: 15
    Last Post: 15th June 2006, 06:42 AM
« Adding new staff in SIMS .NET | Dates in SIMS reports »

Thread Information

Users Browsing this Thread

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

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