+ Reply to Thread
Results 1 to 2 of 2

Sum of a range corresponding to the current week

  1. #1
    Registered User
    Join Date
    12-02-2021
    Location
    Norwich, England
    MS-Off Ver
    Excel for Microsoft 365 MSO - 64-bit
    Posts
    5

    Sum of a range corresponding to the current week

    Hi all,

    I am currently trying to update my works team tracker - we have an overview section at the top of the page which uses a simple countif formula for each person to show their utilisation for each day.
    What I would like to do is show their percentage utilisation for the current week next to the persons name (column B in attached spreadsheet) for this I need it to lookup the current week based on the values in row 2 and then sum up the totals from the corresponding countif formulas - is this possible?

    Many thanks in advance.
    RH
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    06-23-2021
    Location
    Romania
    MS-Off Ver
    2021, 365 v 2208
    Posts
    722

    Re: Sum of a range corresponding to the current week

    Maybe this?

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


    If the solutions offered helped you to solve your problem, then mark the thread as SOLVED (thread tools in the top menu) and you can click on * to add reputation to those who helped you, as a way to say thank you !

+ 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. If statements to check range for dates within current month, week and quarterly.
    By trying-my-best in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-19-2017, 02:55 PM
  2. [SOLVED] Set PivotTable Filter to Current Day, Current Week, Current Month, or Current Year
    By EnigmaMatter in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-30-2014, 08:31 AM
  3. UserForm with that shows Previous Week Data and allows you to update current week
    By hicks1ch in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-22-2014, 09:47 AM
  4. Replies: 2
    Last Post: 03-06-2014, 11:27 AM
  5. Chart previous week data as grouped and current week as ungrouped
    By r_a_c_a_4_u in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-17-2013, 12:55 PM
  6. Display Current Week # according to range.
    By lxa8888 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-25-2012, 05:20 PM
  7. Replies: 4
    Last Post: 03-21-2011, 05:37 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