+ Reply to Thread
Results 1 to 3 of 3

Sum formula for the week

  1. 01-25-2017, 08:09 PM #1
    rizmomin
    rizmomin is offline
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Sum formula for the week

    Hello:

    Please refer to attached file.
    I have Data sheet where there is Sales info for each day.
    I am interetsted in column M (Tota Income) for the week defined in Sheet1 Column B and C.
    I have entered manually data in cell E4....I need formula in cell E4 down.

    Let me know if you have any questions.
    Thanks.

    Riz
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 01-25-2017, 08:14 PM #2
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,936

    Re: Sum formula for the week

    Try his...
    =SUMIFS(Data!M:M,Data!$A:$A,">="&Sheet1!B4,Data!$A:$A,"<="&Sheet1!C4)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  3. 01-25-2017, 09:06 PM #3
    rizmomin
    rizmomin is offline
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Re: Sum formula for the week

    Hello:

    Thanks FDibbins, works

    Riz
    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. Create a formula that recognises a 4 week vs 5 week month for budget savings
    By AnitaNed in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-15-2016, 05:16 PM
  2. Formula to Allocate Cost every week according to the number of days in a week
    By prkhan56 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-14-2015, 12:13 PM
  3. [SOLVED] Need help auto-updating a formula for week over week change
    By yanger87 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-14-2015, 12:45 PM
  4. [SOLVED] Week-wise sum formula on customized week (Mon-Sun)
    By nagesh.tvsr in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-30-2014, 05:03 AM
  5. [SOLVED] Formula to tell when its week 1 or Week 2 of a any given month
    By Shellybelly in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-16-2014, 10:23 AM
  6. [SOLVED] 2 week and 1 week highlight cell formula/conditional format, help please
    By HNoel33 in forum Excel General
    Replies: 4
    Last Post: 04-25-2014, 12:30 PM
  7. Excel 2003 Formula which moves on week by week, linked to another worksheet
    By DavidMarston in forum Excel General
    Replies: 11
    Last Post: 04-06-2011, 02:33 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