+ Reply to Thread
Results 1 to 2 of 2

Counting amount of cells with a numeric value

  1. #1
    Registered User
    Join Date
    09-25-2012
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    3

    Counting amount of cells with a numeric value

    Hi,

    I need to be able to count how many of the twelves month of the year have a numeric value in them, whilst the the rest will be blank. Counting the blank cells is easy, But Im not to sure about the filled cells.

    Any help is much appreciated.
    Last edited by marshall84; 09-26-2012 at 10:04 AM. Reason: Solved issue

  2. #2
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: Counting amount of cells with a numeric value

    =count(a1:a12)
    Gary's Student

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1