+ Reply to Thread
Results 1 to 3 of 3

Count formula

  1. #1
    Registered User
    Join Date
    04-25-2013
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    12

    Count formula

    I have a column of data in sheet 2 of a workbook. The data is all in column A, see sample below

    Sheet2
    A1 Age 1-2
    A2 Age 3-4
    A3 Age 5-6
    A4 Age 7-8

    I need a formula to count how often these sizes appear in column F in sheet 1 and display the result. Is there a formula that will quickly do this?

    Thanks
    Declan

  2. #2
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Count formula

    This should do it. Adjust the range to suit your data. Enter in Sheet2!B1 if your data starts in A1

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,788

    Re: Count formula

    You're profile says 2003, I *think* this will work in 2003. Take a look at the countif() function

    If not, upload a saple workbook (no sensitive data) showing what you are working with, and what you want
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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