+ 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. #1

    Join Date
    Nov 2006
    Location
    Lancashire
    Posts
    95
    Thank Post
    34
    Thanked 1 Time in 1 Post
    Rep Power
    0

    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

  2. #2
    Jona's Avatar
    Join Date
    May 2007
    Location
    Cranleigh
    Posts
    471
    Thank Post
    14
    Thanked 51 Times in 49 Posts
    Rep Power
    24
    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 10:21 AM. Reason: added ref

  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, 02:32 PM
  5. google spreadsheet
    By russdev in forum Educational Software
    Replies: 15
    Last Post: 15th June 2006, 06:42 AM

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
  •