+ Reply to Thread
Results 1 to 6 of 6

Need formula to total invoice amount per month and then total per month per client.

  1. #1
    Registered User
    Join Date
    11-03-2016
    Location
    Houton, TX
    MS-Off Ver
    Office 360 2016
    Posts
    16

    Need formula to total invoice amount per month and then total per month per client.

    Need formula to pull total invoice amount per month pulled from sheet 1 into sheet 2. Also total amount per month per client on sheet 3. I have put comments in the cells I need the info. I think it is a sumproduct but I'm not that good. Not even close.
    Attached Files Attached Files

  2. #2
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,088

    Re: Need formula to total invoice amount per month and then total per month per client.

    Refer attach file.
    in sheet1 additional column "L" create for combine month&year.
    In sheet2 inseart year in cell "A23" : 2016
    Attached Files Attached Files


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  3. #3
    Registered User
    Join Date
    11-03-2016
    Location
    Houton, TX
    MS-Off Ver
    Office 360 2016
    Posts
    16

    Re: Need formula to total invoice amount per month and then total per month per client.

    Perfect for sheet two issue. Now how do I do the sheet three where I need it broke out by client?

  4. #4
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,088

    Re: Need formula to total invoice amount per month and then total per month per client.

    its same as earlier. only criteria as name add with respective range.
    see attach file.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    11-03-2016
    Location
    Houton, TX
    MS-Off Ver
    Office 360 2016
    Posts
    16

    Re: Need formula to total invoice amount per month and then total per month per client.

    OK thank you. I had to tweek the first one to match my range but worked great. I will close post once I get the second formula done.

  6. #6
    Registered User
    Join Date
    11-03-2016
    Location
    Houton, TX
    MS-Off Ver
    Office 360 2016
    Posts
    16

    Re: Need formula to total invoice amount per month and then total per month per client.

    Well couldn't get that to work just came back $0.00. I'll work more on it later.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Add up total amount of occurrences of zero per month
    By jonodillieono in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-08-2016, 11:06 AM
  2. [SOLVED] Add up the total amount of cash depending on the month?
    By mattfen44 in forum Excel General
    Replies: 7
    Last Post: 04-20-2016, 10:29 AM
  3. Summarize total amount with different month
    By umininnel in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-27-2015, 08:28 PM
  4. Total amount if month is januari
    By Octonet in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-18-2015, 11:09 AM
  5. Total amount is month is januari
    By Octonet in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-16-2015, 07:53 PM
  6. Replies: 3
    Last Post: 07-16-2014, 02:53 PM
  7. I am trying to get total amount by month
    By amm_manaz in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-06-2014, 11:54 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1