+ Reply to Thread
Results 1 to 2 of 2

Special COUNTIF

  1. #1
    Registered User
    Join Date
    09-03-2021
    Location
    Toronto
    MS-Off Ver
    13
    Posts
    1

    Cool Special COUNTIF

    Hi, I'm making sheets to track hours and payments for dance classes. Sheet 1 has each class available as a header and then underneath a list of the participants in the class. In sheet 2 I have a schedule where each of the classes from sheet 1 are shown within their allotted times, labelled the same as the headers from sheet 1. Private classes are also shown in this schedule with the name of the student.
    In sheet 3, I want to get the number of hours that a student is in private classes based on the schedule and then separately the number of hours a student is in group classes. The private classes hours I am able to get with a COUNTIF formula which counts how many times the student's name appears in the schedule and therefore how many hours the student is in private classes. I don't know how though to get the number of hours a student is in group classes. I feel like it should be possible but I can't figure it out.

    So just to sum up, if say for example Jessica's name appears under "Jazz" classes column and "Acro" classes column in Sheet 1, I want to count how many times "Jazz" and "Acro" classes appear in the schedule which will will tell me the number of hours that Jessica is in group classes.

    Thanks in advance for any help!

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Special COUNTIF

    Hello jamesden. Welcome to the forum.

    This will need an uploaded workbook sampl. Instructions are at the top of the page. HOW TO ATTACH YOUR SAMPLE WORKBOOK:
    Dave

+ 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. [SOLVED] Countif on visible cells only & Countif from a cell with multiple entry
    By MushroomJ in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-26-2021, 05:37 AM
  2. Replies: 5
    Last Post: 08-12-2020, 05:33 PM
  3. [SOLVED] how to use countif for special cell and not for a range?
    By anilg0001 in forum Excel General
    Replies: 19
    Last Post: 08-06-2018, 03:33 AM
  4. Faster if/countif formula for flagging uniques - countif too slow
    By Speshul in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-19-2015, 01:44 PM
  5. [SOLVED] if a cell has a special value, the whole row should get to a special spreadsheet
    By benjamin.grimm in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-08-2013, 09:50 AM
  6. Need to highlight special character and the cells contains special character
    By dhilipan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-26-2013, 01:36 AM
  7. help writing a special 'COUNTIF'
    By Gixxer_J_97 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-21-2005, 06:06 PM

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