+ Reply to Thread
Results 1 to 9 of 9

Count the number of visits by visit types.

  1. #1
    Registered User
    Join Date
    07-24-2013
    Location
    new york
    MS-Off Ver
    Excel 2003
    Posts
    62

    Count the number of visits by visit types.

    Hello guys,

    I have dataset of doctor visits. These are my variables:

    1. Day of Study (1,2 ,3; three days)
    2. ROOM NUMBER (1,2,3,4; 4 different rooms)
    3. VISIT TYPE (1 to 8; Eight different visits types)
    4. TIME IN (number)
    5. Time OUT (number)

    AS you can see in tab 2, I need to"

    1. count the number of visits each day by Visit type.
    2. Average visit time by visit type. That is, the average time of TIME in - Time out, by visit type.
    3. The maximum and minimum time of visit by visit type.

    I would greatly appreciate if somebody help me with this. So I can learn by looking at the formulas.

    Best,
    MArvin
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Count the number of visits by visit types.

    See if these will help get you started...

    for Type...
    =COUNTIF('DATA ENTRY'!$C:$C,'Data Table'!$A7)
    copied down
    for the days...
    =COUNTIFS('DATA ENTRY'!$C:$C,'Data Table'!$A7,'DATA ENTRY'!$A:$A,RIGHT(C$6,1))
    copied down and across
    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

  3. #3
    Registered User
    Join Date
    07-24-2013
    Location
    new york
    MS-Off Ver
    Excel 2003
    Posts
    62

    Re: Count the number of visits by visit types.

    Thank you very much but it is not working. it is counts of visits by visit type and day of the visit. So in day one, how many visits we have for service type 1, type 2 etc type 2, etc.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Count the number of visits by visit types.

    Thats exactly what the 2nd formula does for you. Did you try it?

  5. #5
    Registered User
    Join Date
    07-24-2013
    Location
    new york
    MS-Off Ver
    Excel 2003
    Posts
    62

    Re: Count the number of visits by visit types.

    Thank you so much.... what about the next part. Average room type.

  6. #6
    Registered User
    Join Date
    07-24-2013
    Location
    new york
    MS-Off Ver
    Excel 2003
    Posts
    62

    Re: Count the number of visits by visit types.

    PLease anyone.. Can somebody help me with the Average visit time by visit type and min aand mav values by visit type?

    Thank you in advance,
    Marvin

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

    Re: Count the number of visits by visit types.

    This is how I see your problem. I don't know what column B is supposed to have so ignored it.
    Attached Files Attached Files
    <---------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

  8. #8
    Registered User
    Join Date
    07-24-2013
    Location
    new york
    MS-Off Ver
    Excel 2003
    Posts
    62

    Re: Count the number of visits by visit types.

    Wow.. I really appreciate it ... Thank you very much. YOu save me!

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

    Re: Count the number of visits by visit types.

    Thank you for the feedback.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. count if - number of types of cells
    By afgi in forum Excel General
    Replies: 8
    Last Post: 08-26-2015, 12:47 AM
  2. [SOLVED] Generate a list number of visits at different times in a day
    By TPS in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-24-2014, 11:16 PM
  3. Formula to assign a visit number
    By Amanco in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-05-2013, 08:42 PM
  4. count / frequency of visits with conditions
    By maymano in forum Excel General
    Replies: 3
    Last Post: 08-19-2011, 03:32 AM
  5. Count a series of number with different types/description
    By bsengineer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-29-2009, 07:40 AM

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