+ Reply to Thread
Results 1 to 4 of 4

Sum Data by week days

  1. #1
    Registered User
    Join Date
    10-12-2008
    Location
    Maldives
    MS-Off Ver
    MS 2010
    Posts
    59

    Sum Data by week days

    I want to sum my data in a separate sheet, by week days for my analysis.
    The data is entered as DATE, INVOICE NO, CUSTOMER, QUANTITY, DAYS TOTAL.
    There will be a new Sheet for every month.
    I can extract the day of the week from the above DATEs by using weekdays function but i am unable to sum the whole sheet by a specific day. I mean for eg. i want the total of all SUNDAYS for he moth of January.
    (sorry i am unable to upload the file.)

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: Sum Data by week days

    Use Weekday function and then use SUMIF function to sum them like
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Or use SUMPRODUCT function to do that without helper column as:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Or use Pivot table

  3. #3
    Registered User
    Join Date
    08-08-2012
    Location
    UAE
    MS-Off Ver
    Excel 2007
    Posts
    43

    Re: Sum Data by week days

    Have you tried the pivot table?

  4. #4
    Registered User
    Join Date
    10-12-2008
    Location
    Maldives
    MS-Off Ver
    MS 2010
    Posts
    59

    Re: Sum Data by week days

    Thanks all, for the help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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