Need formula help for adding months based on criteria of customer
Results 1 to 4 of 4

Thread: Need formula help for adding months based on criteria of customer
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Dec 2004
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Need formula help for adding months based on criteria of customer

    I have a spreadsheet that I need to add each month sales invoices based on customer.

    Here is a sample of what my spreadsheet looks like.



    I would greatly appreciate any help. Thank you in advance!

  2. #2
    Board Regular
    Join Date
    May 2018
    Location
    Sydney
    Posts
    76
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Need formula help for adding months based on criteria of customer

    Hi Lil Dot,

    Copy the formula in cell G2 and copy it across and down to sum numbers based on both on months and customers.

    =SUMPRODUCT(($C$2:$C$6),(--($B$2:$B$6=$F2)),--(MONTH($A$2:$A$6)=VLOOKUP(G$1,{"Jan",1;"Feb",2;"Mar",3;"Apr",4;"May",5;"Jun",6;"Jul",7;"Aug",8;"Sep",9;"Oct",10;"Nov",11;"Dec",12},2,FALSE)))

    You will have to expand C2:C6 ranges in the formula to your desired range.

    Kind regards

    Saba

  3. #3
    New Member
    Join Date
    Dec 2004
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Need formula help for adding months based on criteria of customer

    Thank you very much Saba! Your formula works perfect!

  4. #4
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,585
    Post Thanks / Like
    Mentioned
    20 Post(s)
    Tagged
    1 Thread(s)

    Cool Re: Need formula help for adding months based on criteria of customer

    this is simply for Pivot Table

    Sum of Amount Date
    Cust Jan Feb Mar
    CustA
    81.6
    52.01
    57.02
    CustB
    103.24
    45.78
    83.77
    CustC
    130.6
    2.38
    116.85
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •