+ Reply to Thread
Results 1 to 9 of 9

How to get summary/count of task on weekly basis

  1. 12-10-2013, 08:13 AM #1
    SJ73
    SJ73 is offline
    Registered User
    Join Date
    12-10-2013
    Location
    Bangalore
    MS-Off Ver
    Excel 2010
    Posts
    5

    How to get summary/count of task on weekly basis

    I am trying to make my excel sheet more robust to get data on weekly basis. I assign tasks to different members of team by entering the assigned date in column next to the member names. Next week, say on Monday, I need to get total number of tasks assigned for each of the members till Friday (last working day of previous week!).
    I need to get this data every week. Can anyone help me on this?

    Thanks in advance for your time!
    Reply With QuoteRegister To Reply
  2. 12-10-2013, 08:15 AM #2
    XOR LX
    XOR LX is offline
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: How to get summary/count of task on weekly basis

    Hi and welcome to the forum!

    Did you forget to attach your worksheet?

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/
    Reply With QuoteRegister To Reply
  3. 12-10-2013, 08:42 AM #3
    SJ73
    SJ73 is offline
    Registered User
    Join Date
    12-10-2013
    Location
    Bangalore
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: How to get summary/count of task on weekly basis

    Sorry, I now added excel sheet!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 12-10-2013, 09:27 AM #4
    XOR LX
    XOR LX is offline
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: How to get summary/count of task on weekly basis

    Thanks, but it's not clear what you are trying to achieve.

    Could you re-post your attachment with your desired results manually added?

    Regards
    Reply With QuoteRegister To Reply
  5. 12-10-2013, 01:33 PM #5
    SJ73
    SJ73 is offline
    Registered User
    Join Date
    12-10-2013
    Location
    Bangalore
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: How to get summary/count of task on weekly basis

    Hi,
    I updated the excel sheet per my requirement and attached again. please check and let me know your comments.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 12-10-2013, 01:54 PM #6
    XOR LX
    XOR LX is offline
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: How to get summary/count of task on weekly basis

    Thanks. Your table contains only tasks done in the 'previous' week, so the formula is simply (in J5 and copied down):

    =COUNTIF($D$5:$D$14,I5)

    If your table will actually contain more than just this period's worth of dates, then you need to re-do your example spreadsheet to reflect this, and obviously amend your desired results accordingly.

    Regards
    Reply With QuoteRegister To Reply
  7. 12-11-2013, 01:07 PM #7
    SJ73
    SJ73 is offline
    Registered User
    Join Date
    12-10-2013
    Location
    Bangalore
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: How to get summary/count of task on weekly basis

    Data in the sheet will be dynamic as it keeps changing every day. As I mentioned earlier, I need to have the data every week till the end of previous week. So the data keeps adding in the main sheet and in the summary area against each member, I should be able to see the weekly summary. Is it doable? Pls advice.
    Reply With QuoteRegister To Reply
  8. 12-15-2013, 10:59 AM #8
    SJ73
    SJ73 is offline
    Registered User
    Join Date
    12-10-2013
    Location
    Bangalore
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: How to get summary/count of task on weekly basis

    Hello XOR LX,
    Let me know if you are clear on my requirement and please advice how this can be obtained.

    Thank you!
    Reply With QuoteRegister To Reply
  9. 12-16-2013, 06:20 AM #9
    XOR LX
    XOR LX is offline
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: How to get summary/count of task on weekly basis

    Hi,

    As I said, the data you posted was not a very good representation of your actual query, so you need to re-post the attachment so that it is precisely that. At the moment, your table contains only tasks done in the 'previous' week, so it is not very useful in terms of providing you with a solution.

    Kindly insert more data and make sure to update your desired results.

    Regards
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Outlook AutoSend an Email for a Weekly Basis
    By Cansa in forum Outlook Programming / VBA / Macros
    Replies: 1
    Last Post: 10-25-2012, 02:03 AM
  2. Need to count productivity by weekly and daily basis
    By marc5354 in forum Excel General
    Replies: 4
    Last Post: 10-06-2010, 01:36 PM
  3. Changing a roster on a weekly basis
    By tug in forum Excel General
    Replies: 0
    Last Post: 05-27-2007, 08:26 AM
  4. pivot tables:weekly basis
    By stef in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-22-2006, 08:30 PM
  5. IRR weekly basis cashflow
    By alimirfarhad in forum Excel Formulas & Functions
    Replies: 23
    Last Post: 09-06-2005, 09:05 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1