+ Reply to Thread
Results 1 to 6 of 6

Calculate % Paid for each Quarter (Google Sheets)

  1. #1
    Registered User
    Join Date
    02-27-2009
    Location
    saco
    MS-Off Ver
    Google Docs
    Posts
    57

    Calculate % Paid for each Quarter (Google Sheets)

    I am attempting to calculate the percent paid per quarter for my workbook. I have checkboxes in sheet and when paid for the month they get checked off (True/False). I then named each range for quarter accordingly. IE Q1, Q2 etc. Issue I am having is the percents are not coming up properly. I have included a sample workbook here https://docs.google.com/spreadsheets...it?usp=sharing

    I just need it to calculate each user that has paid and then divide that by total ACTIVE users. It should not include inactive in the calculation. I can not grasp how to accomplish this.

    Thank you community!
    Last edited by DAVIDJMORIN; 03-27-2024 at 10:56 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,852

    Re: Calculate % Paid for each Quarter

    If you are using GoogleSheets, please update your profile to reflect this. Thanks.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    02-27-2009
    Location
    saco
    MS-Off Ver
    Google Docs
    Posts
    57

    Re: Calculate % Paid for each Quarter

    I added it to my title.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,852

    Re: Calculate % Paid for each Quarter (Google Sheets)

    Thanks. You need to update your profile as well, please.
    Attached Images Attached Images

  5. #5
    Registered User
    Join Date
    02-27-2009
    Location
    saco
    MS-Off Ver
    Google Docs
    Posts
    57

    Re: Calculate % Paid for each Quarter (Google Sheets)

    So far I came up with this.

    Please Login or Register  to view this content.
    Must be a more efficient way though.

  6. #6
    Registered User
    Join Date
    02-27-2009
    Location
    saco
    MS-Off Ver
    Google Docs
    Posts
    57

    Re: Calculate % Paid for each Quarter (Google Sheets)

    Ok so this is what I was looking for, Basically I created a column for Q1 to add 1 if all paid and 0 if not all paid. Then used that to find my % paid.

    Please Login or Register  to view this content.
    Then for the %

    Please Login or Register  to view this content.

+ 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] Macro to help calculate the amount of payment and when it should be paid
    By nettadecoco in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-14-2023, 08:39 AM
  2. [SOLVED] Calculate only PAID Invoices
    By rameshantony2000 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-29-2023, 06:13 AM
  3. [SOLVED] How to calculate a cost column when status is paid
    By JonniBravo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-16-2021, 06:39 AM
  4. [SOLVED] Calculate Quarter (date) and Calculate Average of Quarter and Sum of Quarter
    By Bobbbo in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 02-26-2020, 06:16 PM
  5. formula to calculate sum of principal paid in an annuity
    By excsal in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-13-2014, 12:00 PM
  6. Formula to calculate amounts paid per account
    By Hblbs in forum Excel General
    Replies: 3
    Last Post: 11-05-2010, 08:17 AM
  7. How to calculate what was paid and what is owed
    By psychson in forum Excel General
    Replies: 2
    Last Post: 02-05-2010, 03:18 AM

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