Results 1 to 14 of 14

Summary of cost for Date Ranges by Month/year

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-11-2010
    Location
    England
    MS-Off Ver
    Excel 2019
    Posts
    203

    Summary of cost for Date Ranges by Month/year

    Hi guys,

    i have attached the spreadsheet

    basically I am trying to total this spreadsheet up to work out a sum for the month by customer number.
    some customers made a payment in jan 2012 and paid again in jan 2013, some paid twice in one month.

    what needs to happen is

    it needs to have customer number going down and the month/year going across the top with a summary paid for that month

    i have attached the spreadsheet.

    can anyone help?
    Attached Files Attached Files
    Last edited by m_789; 08-22-2013 at 07:42 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Sort month/date/year data using month and date only
    By SMW820 in forum Excel General
    Replies: 8
    Last Post: 11-18-2014, 08:39 AM
  2. Replies: 3
    Last Post: 09-04-2013, 10:49 AM
  3. If Column A Month and Year = ColumnB Todays Month and Year then send email
    By HACCStaff in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-15-2013, 12:47 AM
  4. Replies: 3
    Last Post: 01-14-2012, 02:33 PM
  5. formula for prior month & year of a month end date.
    By mikeburg in forum Excel General
    Replies: 2
    Last Post: 09-25-2007, 04:01 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1