+ Reply to Thread
Results 1 to 7 of 7

Count blanks cells

Hybrid View

jmumby Count blanks cells 05-06-2006, 06:14 PM
Guest RE: Count blanks cells 05-07-2006, 05:45 AM
jmumby Thanks for the reply! I... 05-07-2006, 06:46 AM
Guest Re: Count blanks cells 05-07-2006, 05:10 PM
jmumby Hey, Thanks for your help!... 05-08-2006, 04:03 PM
Guest Re: Count blanks cells 05-08-2006, 05:15 PM
jmumby Hey, Your the man! It... 05-09-2006, 05:52 AM
  1. #1
    Domenic
    Guest

    Re: Count blanks cells

    It looks like for some reason you've entered the formula in an array of
    cells. Instead, enter the formula in H2 only, confirm with
    CONTROL+SHIFT+ENTER, and then copy/drag down and across. Also, since
    Column G contains no data, adjust the ranges accordingly. Post back if
    you need further help...

    In article <jmumby.27i92q_1147119010.3468@excelforum-nospam.com>,
    jmumby <jmumby.27i92q_1147119010.3468@excelforum-nospam.com> wrote:

    > Hey,
    >
    > Thanks for your help!
    >
    > I am pretty sure I followed your instructions word for word but I just
    > seem to get blank cells now?
    >
    > You can find the actual spreadsheet here
    > http://labtrack.dpn.homeip.net/number_thing.zip
    > if you get an opportunity perhaps you can tell me where I am going
    > wrong?
    >
    > Thanks,
    >
    > Jason


  2. #2
    Registered User
    Join Date
    05-06-2006
    Posts
    4
    Hey,

    Your the man!

    It was just a case of me not entering the formula properly.

    Would it be easy enough to modify that formula so that it counted cells below rather than above?

    Thanks for your help!

    Jason
    Last edited by jmumby; 05-09-2006 at 06:27 AM.

+ 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