Results 1 to 6 of 6

Fomula to consolidate month total

Threaded View

  1. 08-31-2020, 10:54 AM #1
    rizmomin
    rizmomin is offline
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Fomula to consolidate month total

    Hello:

    Please refer to attached file.
    I have data in column H of sheet "Store1" and "STore2" for Date shown in Column G.

    I need Formula in Sheet "Summary" in Cell B4 and B5 to give total for given month entered in cell A3.

    Let me know if you have any questions.
    Thanks.
    Riz
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« 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] Calculate a YTD Total based on Reporting Month and Week of Month via drop down selections
    By Miskondukt in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-02-2018, 05:14 PM
  2. Need formula to total invoice amount per month and then total per month per client.
    By TGHEAD in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-08-2016, 04:24 AM
  3. [SOLVED] Dynamic fomula for Month, Qtr and YTD
    By 4gurus in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 07-24-2016, 05:05 PM
  4. [SOLVED] Consolidate invoice total for differnt store
    By rizmomin in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 11-14-2014, 06:56 PM
  5. [SOLVED] Rolling 12 month total formula which will automatically change at new month
    By TotallyLost in forum Excel General
    Replies: 3
    Last Post: 07-16-2014, 02:53 PM
  6. [SOLVED] Need help with date and total fomula
    By BillWatson in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-19-2012, 11:27 AM
  7. Excel 2007 : How to consolidate same days and total revenue?
    By techboy2011 in forum Excel General
    Replies: 5
    Last Post: 04-12-2011, 03:30 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1