+ Reply to Thread
Results 1 to 3 of 3

Finding weekly percentage of items

  1. #1
    Registered User
    Join Date
    09-03-2013
    Location
    Belfast, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    18

    Finding weekly percentage of items

    Hello all,

    I've attached some data:
    Sample Data Excel.xlsx

    Basically I am trying to see what percentage per week of items have been reviewed within/equal to a two-day deadline.
    The values in column H count up the items that have been reviewed and the number of days it has taken. The overall percentage is shown in cell G4.
    Is there a way of splitting this by week and calculating the overall weekly percentage?

    Thank you

  2. #2
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: Finding weekly percentage of items

    Try

    =COUNTIFS($H$12:$H$24,"<=2",$A$12:$A$24,">="&J13,A12:A24,"<"&J13+7)/COUNTIFS($A$12:$A$24,">="&J13,$A$12:$A$24,"<"&J13+7)

  3. #3
    Registered User
    Join Date
    09-03-2013
    Location
    Belfast, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: Finding weekly percentage of items

    I think that's done it! Wow, thanks a lot!

+ 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. How to see percentage of items received daily, weekly, monthly?
    By ConfusedCitizen in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 04-21-2013, 03:44 PM
  2. [SOLVED] Finding Weekly Totals
    By gocush in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-24-2012, 07:46 PM
  3. finding weekly hours
    By rawindar in forum Excel General
    Replies: 1
    Last Post: 09-20-2012, 08:29 AM
  4. Preparing Weekly attendance Percentage of Agents
    By luckyros in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 02-27-2008, 09:49 PM
  5. [SOLVED] Move items into weekly calendar
    By normajmarsh in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-24-2006, 10:15 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