+ Reply to Thread
Results 1 to 9 of 9

Calculate the % of attendance to meetings

  1. #1
    Registered User
    Join Date
    01-19-2021
    Location
    Montreal
    MS-Off Ver
    360
    Posts
    2

    Calculate the % of attendance to meetings

    Hello,

    I'm wondering which is the best formula to count the attendance of meetings.

    formula.png

    I attached a screenshot for reference.

    Basically I have been trying to calculate the % of attendance to meetings. When I use the COUNTIF formula, it counts the active members. However, if a member becomes inactive at a certain date, it will trick all the previous meetings stats and the ones he attended.

    How can I calculate the % of attendance of members who were active when the meeting occurred? I don't want the formula to count members who were inactive at that time or not yet active members.

    Many thanks for your help!
    Last edited by AliGW; 01-20-2021 at 02:19 AM.

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    28,341

    Re: Countif?

    Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

    Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

    To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Expert
    Join Date
    07-06-2004
    Location
    Northern California
    MS-Off Ver
    2K, 2003, 2010, O365
    Posts
    1,443

    Re: Countif?

    There is no such thing as Office 360.

    C4:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Fill down as far as needed.
    Last edited by hrlngrv; 01-20-2021 at 02:12 PM. Reason: possibile approach

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 10)
    Posts
    49,690

    Re: Calculate the % of attendance to meetings

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

    Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

    Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

    (Note: this change is not optional. As you are new I have done it for you today.)
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  5. #5
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    28,341

    Re: Countif?

    @hringrv

    Hi, the request to upload a file in #2 was just that, a request not a mandatory requirement - and made in the OP's own interests.
    There is no rule which makes uploading a file mandatory and hence you were entitled to offer your solution in the absence of a file. Please go ahead and reinstate the solution.

    @polypus. Just a reminder. Rarely are pictures much use. You have a file so why not upload it. Cut it down in size if necessary, all we need is a representative sample.

  6. #6
    Forum Expert
    Join Date
    07-06-2004
    Location
    Northern California
    MS-Off Ver
    2K, 2003, 2010, O365
    Posts
    1,443

    Re: Countif?

    I've received warnings from other mods for having posted solutions which I began working on BEFORE mods had issued requests for workbook attachments. While there's apparently little consistency between mods, I prefer not to take chances on possible rules violations. However, since there's no rule against publicizing such actions on my part . . .

  7. #7
    Registered User
    Join Date
    01-19-2021
    Location
    Montreal
    MS-Off Ver
    360
    Posts
    2

    Re: Countif?

    Hi Richard,
    For some reason I can't seem to be able to attach a document, When I click on the button there is a white space as a pop-up but nowhere I can click to attach my file. Any idea what to do?
    Thanks

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 10)
    Posts
    49,690

    Re: Countif?

    Quote Originally Posted by hrlngrv View Post
    I've received warnings from other mods for having posted solutions which I began working on BEFORE mods had issued requests for workbook attachments. While there's apparently little consistency between mods, I prefer not to take chances on possible rules violations. However, since there's no rule against publicizing such actions on my part . . .
    The OP is new and I stated at the end of the notice that I have made the change for them this time. Requests for workbooks are NOT moderation requests that stop the thread - they are never accompanied by a notice saying that no help may be given until a workbook is provided. I think you are getting muddled between administrative notes (title changes, missing code tags, cross-post links, etc.) and simple requests for more information.
    Last edited by AliGW; 01-20-2021 at 06:36 PM.

  9. #9
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    28,341

    Re: Countif?

    Quote Originally Posted by polypus View Post
    Hi Richard,
    For some reason I can't seem to be able to attach a document, When I click on the button there is a white space as a pop-up but nowhere I can click to attach my file. Any idea what to do?
    Thanks
    Have you followed the instructions in the yellow banner at the top of the forum?

+ 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. Replies: 5
    Last Post: 08-12-2020, 05:33 PM
  2. Adding a COUNTIF function to an existing IF AND COUNTIF Formula...
    By Ourkid123uk in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-24-2018, 10:09 AM
  3. Replies: 8
    Last Post: 05-27-2017, 07:04 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. Combining a Date Range COUNTIF and a general COUNTIF
    By jacobtom in forum Excel General
    Replies: 1
    Last Post: 09-15-2011, 05:06 PM
  6. Adding a CountIF to a formula that is already Countif
    By Cmorgan in forum Excel General
    Replies: 4
    Last Post: 06-01-2011, 09:34 AM
  7. [SOLVED] Countif w/ Multiple Criteria-How do I use countif
    By Patrick_KC in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-09-2005, 05:05 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