+ Reply to Thread
Results 1 to 3 of 3

How do you count the number of values in a row from a seperate sheet?

  1. #1
    Registered User
    Join Date
    04-16-2012
    Location
    Nicaragua
    MS-Off Ver
    Excel 2003
    Posts
    4

    Question How do you count the number of values in a row from a seperate sheet?

    Hi!

    I want to count the number of rows (with a value in them) from a seperate sheet. What is the formula for that?

    Example.

    I have a colum with 200 values and on a seperate sheet I want to insert a formula that will automatically count the number of entries in that colum. Is there a way to do that? Your help will be greatly appreciated.

    Thanks!

  2. #2
    Forum Expert DGagnon's Avatar
    Join Date
    02-23-2012
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2003, 2007
    Posts
    1,645

    Re: How do you count the number of values in a row from a seperate sheet?

    you can do that with a counta, something like this:

    =COUNTA(Sheet2!A:A)
    If you liked my solution, please click on the Star -- to add to my reputation

    If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.

  3. #3
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: How do you count the number of values in a row from a seperate sheet?

    Be careful with COUNTA() - it counts formulas returning "".

    Maybe COUNTIF(range,"?*")

    Maybe COUNT()

    Depends on the values you want to count.

+ 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